Submitted by KeithB on 2009/09/11 12:17
How?  I have a date field, and want to have another field that gives the day of the week of the date field.    9/11/09 --> Friday. 
 

Comments

KeithB

2009/09/11 15:39

Permalink

Thanks.  I'll try to put that info in the manual.
 
Also doing the same for "year" is going to be very handy also:
 
<source>SELECT ItemID, Format([Date],"yyyy") AS Year
FROM ¯qDate;</source>

Armando

2009/09/11 15:53

Permalink

Keith : I did it earlier (in the smart folder section). But feel free to change/add any details...