date problem

[zedan]

Hi
how can i change date format
i want to display 02/03/2005 in this format 02/03/05
i have MS. Access database

thanks

[PeejAvery]

Did you even search the Help file before posting? Microsoft does have an extensive help file and if not there you could always check online. Did you check these two resources first?

http://www.google.com/search?hl=en&lr=&safe=off&q=microsoft+access+date+format&btnG=Search

[srikanthvja]

hi,


try this

select format( start_date,"dd/mm/yy"), start_date, format( now,"ddmmyy") from payee

enjoy vb programming...
all the best

[PeejAvery]

I am confused, zedan. Are you trying to do the date format change in Microsoft Access or in Visual Basic? If you are attempting to do so in Microsoft Access thensrikanthvja, your coding is for programming. If it is for programming, then zedan, why did you mention you had Microsoft Access.

Zedan,

My guess is that if you right click on the column header for the date in Microsoft Access, you could go to the properties of that column. There you could change the standard format from the default to what you would like it to be.