-
Weird Format Date()
Hi Everyone!
I am having this really weird thing when I try to make a tekst field display the date in for example this way =Format(Date();"dd mmmm jjjj"). When I try to do it like that Access autocorrects the code to =Format(Date();"dd mmmm"" jjjj""") The jjjj are correct because I'm from holland, I have tried yyyy.
This leaves me with a date like "9 march jjjj".
Does anyone know why this is and how to resolve it?
Many thanks Gurus,
Jasper
-
Ahum,
Never mind, it was a typo.
Sorry gurus,
Jasper
-
When you replaced the jjjj with yyyy, did you remove the extra quotes?
i.e. Format(Date();"dd mmmm"" jjjj""") to Format(Date();"dd mmmm yyyy")
-
Hi jp140768,
Sorry for this post, it was just a mis type. But I am thankfull for your reply.
Regards,
Jasper