How do I convert a date to text in Access XP

[Guest]

Can anyone advise the code to use an Access query to convert a date or time
to a string - e.g. 04/07/2005 to 04072005?

Thanks

 

[Guest]

Try this, convert to string after formating

cstr(format([DateField],"ddmmyyyy")

 

[Douglas J. Steele]

Use the Format function: Format(MyDateField, "ddmmyyyy")

 

[Guest]

If you want to add the time up to seconds then

=cstr(format([MyDate],"ddmmyyyyhhmmss")

 

[John Spencer (MVP)]

Whoops.

The format character for minutes is "n" not "m" - m is already used for Month,
so some other character has to be used for minutes.

=cstr(format([MyDate],"ddmmyyyyhhnnss")

Also, FYI the format function creates a string, so CStr is not really needed.

If you want to add the time up to seconds then

=cstr(format([MyDate],"ddmmyyyyhhmmss")

Can anyone advise the code to use an Access query to convert a date or time
to a string - e.g. 04/07/2005 to 04072005?

Thanks

 

[Guest]

Thank you

Whoops.

The format character for minutes is "n" not "m" - m is already used for Month,
so some other character has to be used for minutes.

=cstr(format([MyDate],"ddmmyyyyhhnnss")

Also, FYI the format function creates a string, so CStr is not really needed.

If you want to add the time up to seconds then

=cstr(format([MyDate],"ddmmyyyyhhmmss")

Can anyone advise the code to use an Access query to convert a date or time
to a string - e.g. 04/07/2005 to 04072005?

Thanks

 

[E-mail report using Lotus Notes rather t]

Ofer,

You are a god...I can just kiss you man...I been looking for this for a
while...thank you so much dude...

Try this, convert to string after formating

cstr(format([DateField],"ddmmyyyy")

Can anyone advise the code to use an Access query to convert a date or time
to a string - e.g. 04/07/2005 to 04072005?

Thanks

 

[John Spencer]

Overkill. Format always returns a string, so there is no need to use CStr

Format(DateField,"ddmmyyyy") will have the same result as
CStr(Format(DateField,"ddmmyyyy"))

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Ofer,

You are a god...I can just kiss you man...I been looking for this for a
while...thank you so much dude...

Try this, convert to string after formating

cstr(format([DateField],"ddmmyyyy")

Can anyone advise the code to use an Access query to convert a date or time
to a string - e.g. 04/07/2005 to 04072005?

Thanks