|
-
Jun 27th, 2008, 12:29 PM
#3
Re: Formatting a date
The following characters are used to create format strings for Date, Time, and DateTime values:
ToText({Table1.Date1},"dd-MMMM-yy")
Character Comments
d day of month without leading zero for single digits
dd day of month with leading zero for single digits.
ddd day of week as a three letter abbreviation
dddd full name of day of week
M month without leading zero for single digit
MM month with leading zero for single digit
MMM month as three letter abbreviation.
MMMM full name of month
yy l ast two digits of year
yyyy full four digits of year
JG
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|