date format

[Guest]

Hello,
endDate = Format(Now(), "yyyymmdd") this should retirn 20041101 but it
returns 20043601. What is problem?
Thanks
Jim.

 

[diliev]

You need capital MM for month, lower case is for minutes.
"yyyyMMdd".

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*

 

[ShaneB]

Format(Today(), "yyyyMMdd")

ms-help://MS.VSCC.2003/MS.MSDNQTR.2003APR.1033/vblr7/html/vafmtuserdefineddateformats.htm

ShaneB