Skip to Content
Former Member
Jan 09, 2008 at 04:32 PM

Converting DateTime to Weekday


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.