DateTime in VB

[subbu]

Hi,
I am looking of for the function which gives me the date
in YYYYMMDDHHMMSS format

Any help in this regard is highly appreciated

subbu

 

[S.L.]

format(<your date>,"yyyymmddhhnnss") or more readable form is format(<your
date>,"yyyy-mm-dd hh:nn:ss")

HTH
Suntisuk

 

[Cheryl Fischer]

The following should do it:

Format(Now(), "YYYYMMDDHHMMSS")

 

[losmac]

Format("YYYYMMDDHHMMSS", Date)