Convert a Date to Day of the Week

Question

Hi All,

I am struggling to convert a date field to a day of the week. I have replaced the "|" with "-" and attempted to use a DateTime function with the a DateTimeFormat formula. This returns Null values.

Any thoughts?

Date                DateTime_Out
12|30|1948     1948-12-30
03|14|1974     1974-03-14
08|22|1958     1958-08-22

Thanks,

Mark

Jonathan-Sherman · Accepted Answer

Hi @MJep.,

You could use the DateTimeFormat() function in a formula tool to convert your DateTime field to the day of the week:

DateTimeFormat([DateTime_Out],'%A')

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan