date of birth input mask help 1

[patrichek]

Hi,
My database is linked to a table in an ms sql db. I run a label maker report from the sql server db but i'm having problems with the date input mask. The date is stored in sql like: 19430829 ( year, month and day) how can i get it to show as mm/dd/yyyy on my labels? Right now its coming out 1943/08/29.

thanks in advance!

 

[AlexMidd]

You probably need to convert it to a date data type, then apply the format "mm/dd/yyyy" for output to the report.

Have fun! )

Alex Middleton

 

[snyperx3]

or you could use an unbound textbox with the following line in it:

= Mid([date],5,2) & "/" & Right([date],2) & "/" & Left([date],4)

-Pete

 

[patrichek]

thanks Pete, i'll try it!