Function to Convert Date to Day of the Week

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

··· On Sun, Mar 20, 2016 at 6:25 PM, YAW ANTWI-ADJEI wrote:

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