How to display date as dd-mm-yy

[FuzMic]

Hi guys

I want a form "date" field set as "dd-mm-yy" format whenever a user arrive at field irrespective of what "region" setting his pc is

In the "Format" of the form text box, if i choose "short date" it will use the pc short date format which may be eg dd/mm/yyyy.

How to fix this, cannot break through this block. Help.

 

[jdraw]

Try
Format(yourDateField,"dd-mm-yy") for displaying Dates as you want them

See this link for Allen Browne's comments on Dates.

 

[FuzMic]

Thank you jdraw. I actually finally put dd-mm-yy in the format properties of the text box and input mask as 99\-99\-00;0; it of course worked as you have said. My earlier mistake is to put the format between "".

 

[jdraw]

You are welcome. Happy to help.

 

[Mark_]

FuzMic,

Just to be clear, you are trying to have a uniform interface regardless of user preferences, correct? This doesn't mean you are trying to "Save" the date in a specific format, correct?

 

[FuzMic]

Mark you are perfectly right. Thanks!