Weird Format Date()

[Jasper XAFAX]

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

[Jasper XAFAX]

Ahum,

Never mind, it was a typo.

Sorry gurus,

Jasper

[jp140768]

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")

[Jasper XAFAX]

Hi jp140768,

Sorry for this post, it was just a mis type. But I am thankfull for your reply.

Regards,

Jasper