Date Format Problem

[kbrad]

I am trying to create an application which needs all the dates to be format
dd.mm.yy (not for me I might add!!!)
I have set up an input mask for the user to enter the date in this format
but when the date is stored in the table it is not the date that was input.
Presumably I need to reformat the date some how before I update the table it
is being written to. Any clues?
After that is it then possible to display it in the dd.mm.yy format or does
it need to be converted back to that from how it is stored for display?

 

[Helen]

Hi,

I think the format is to do with your region coding in Windows. Are you
working on tables or forms?

 

[kbrad]

Both - the date is input through a form then the table is updated via code
behind the form.

 

[Guest]

hi,
you put the input mask in the form i assume but
the table also has an input mask and format. did you
change it in the table to match the form?

 

[kbrad]

Yes I did change the table input mask.

hi,
you put the input mask in the form i assume but
the table also has an input mask and format. did you
change it in the table to match the form?