Converting DateTime to Weekday

[Former Member]

Post Author: cook754

CA Forum: Formula

I am using an old RMS that stores our dates as a DateTime. The time associated with this field is not accurate or used and the true time is actually stored in a different field. The problem that I constantly run into is that everything I import the field into for analysis (Crystal, Excel, Access, etc.) sees the field as a DateTime.

I am trying to create a formula field that displays the Weekday on the table from this DateTime field, but I can't figure out how to do this. Any help would be appreciated.

Thank you.

[Former Member]

Post Author: cook754

CA Forum: Formula

Excellent. Thank you very much!

[Former Member]

Post Author: Jagan

CA Forum: Formula

Look at the help for the Date() function and Weekday.. functions.

weekdayname(weekday(date(currentdatetime)))