date format

[JIM.H.]

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

[ShaneB]

Re: date format

Format(Today(), "yyyyMMdd")

ms-help://MS.VSCC.2003/MS.MSDNQTR.2003 APR.1033/vblr7/html/vafmtuserdefine ddateformats.ht m

ShaneB

"JIM.H." <JIMH@discussio ns.microsoft.co m> wrote in message
news:978EE4D5-7386-4D24-9A85-D79BD82DF514@mi crosoft.com...[color=blue]
> Hello,
> endDate = Format(Now(), "yyyymmdd") this should retirn 20041101 but it
> returns 20043601. What is problem?
> Thanks
> Jim.
>[/color]

[diliev]

re:date format

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

*-----------------------*
Posted at:

https://www.GroupSrv.com

*-----------------------*