Understanding DATE fomat

[djclntn]

Hey Orange,
Not to gloat, but I was successful at using your example to implentment it in another Table/Query. I still have one more Table/Query to tackle, but that will be tomorrow.



I really get myself down & bummed out when I can't understand & get the results I'm looking for, but boy does it feel good when you're successful!

[djclntn]

Orang, given your example above, how can I change the months from being #'s to 3-letters?
1 -- Jan
2 -- Feb
etc

[orange]

Glad you got it working.


For 3 character date you need a format like
?Format(Date,"mmm")
Nov
?Date
11/24/2011
?Month(Date)
11
?MonthName(Month(Date))
November
?Format(Date,"mmm")
Nov