Hi everyone,
I am in need of help converting a string yymmdd (ex: 080907 = Sept 7, 2008) to a date format as dd/mm/yyyy. I need to do this in a query or visual basic code?
Hi everyone,
I am in need of help converting a string yymmdd (ex: 080907 = Sept 7, 2008) to a date format as dd/mm/yyyy. I need to do this in a query or visual basic code?
Have you tried using the Mid() function?
Yes, I ended up using
CDate(mid([date],24),left([date],2),right([date],2)) to format it to mm/dd/yy
then short date format on filed property to make it mm/dd/yyyy
Glad you got it sorted. BTW, using date as a field name can be problematic since it is a reserved word. http://www.allenbrowne.com/AppIssueBadWord.html
Lol, I have learned that the hard way. It is actually named nDate.
Thanks!