Discussion Locked

Access 97 Dates

0 helpful

3 replies

by mra2 Aug 26, 2004 last reply Aug 30, 2004

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a date field on my form called Termination Date. I have the input mask set up for MM/DD/YYYY for easy data entry.

Now I am trying to export a Report to another system. Those people MUST have the date in
YYYYMMDD format with NO SEPERATORS.

How can I format the date in my report to YYYYMMDD with NO SEPERATORS????

Your help is greatly appreciated!!!!

Alan

3 replies

dim str1 as string
dim result as string

str1=format(TheDate,"yyyy.mm.dd")
result=mid(str1,1,4) & mid (str1,6,2) & mid(str1,9,2)

Thanks!!!

This question was closed by the author

This discussion is closed to new replies.