date europen style

  • Thread starter Thread starter Ran BD
  • Start date Start date
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
 
thanks tom it really helped
Tom said:
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
 
Back
Top