date europen style

[Ran BD]

what do I do to get a date European style ?
AKA dd/mm/yyyy ?

Thanks

 

[Tom]

Do you mean short of changing the settings in your regional settings on
windows?
Probably the best option besides above would be to create a public function
which changes the format - or else you have to use the Format command at
each date in your programming and at each control on your forms you will
need to set the format to dd/mm/yyyy.
I suggest setting the regional settings! One thing to keep in mind which I
found out the hard way, JET always requires dates for comparison in the
American format. Thanks to some great help from this forum, I solved a
problem like that which had been driving me nuts!
HTH
Tom

 

[Ran BD]

thanks tom it really helped

Do you mean short of changing the settings in your regional settings on
windows?
Probably the best option besides above would be to create a public function
which changes the format - or else you have to use the Format command at
each date in your programming and at each control on your forms you will
need to set the format to dd/mm/yyyy.
I suggest setting the regional settings! One thing to keep in mind which I
found out the hard way, JET always requires dates for comparison in the
American format. Thanks to some great help from this forum, I solved a
problem like that which had been driving me nuts!
HTH
Tom