Submitted by jan_rifkinson on 2009/04/20 08:51
Is there a way to automate the day of week as it relates to a date?
 
Example, In apptdate column I have date + time. Would like to have another column w day of wk automatically populated based on apptdate data
 
Thanks,
 
--
Jan Rifkinson
Ridgefield CT USA

Comments

The sample app has a Day field (type=Text). Field management > Options:
 
<source>SELECT ItemID, Format([Date],"ddd") AS Day
FROM ¯qDate;</source>
 
This gives the day of the week for the Date field. Simply change Date for apptdate and it will do it for that field!