Dear All,
I would like to convert the day part of a date to DAY of the week such as
(Monday, Tuesday, Wednesday, etc) but can find the function to do just
that. Please help me if you can.
I have seen the TEXT function in Excel but that uses a Cell as an argument.
Yaw
Hi Yaw,
According to this page on our helpsite:
https://wiki.commcarehq.org/display/commcarepublic/CommCare+Functions
Using the "format-date" function and '%a' will give you a three letter day
of the week (Sun, Mon, etc.)
example: format-date(date(/data/my_date),"%a") should retrun "Sun"
Hope that solves your problem!
-A
Dear All,
I would like to convert the day part of a date to DAY of the week such as
(Monday, Tuesday, Wednesday, etc) but can find the function to do just
that. Please help me if you can.I have seen the TEXT function in Excel but that uses a Cell as an argument.
Yaw
--
You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Andrea Fletcher, MPH | Project* Manager | Dimagi, Inc.*
585 Massachusetts Ave, Cambridge MA
United States: +1724.840.8809
Skype: andrea-fletcher