A Question about Dates

[Bachfile]

I have a field on a form where the date is input. Right now, as a Medium Date field microsoft wants it dd/mm/yyyy and I was wondering how I could change that to mm/dd/yyyy? is there a way to use an input mask for that? it doesn't look like any other of the date choices would help.

Thanks

 

[Pat Hartman]

The default date format is controlled by Windows. If you want to change ALL dates for your PC to month, day, year order, change the date format in the Windows Control Panel. If you only want to change a single field, do it with a format. You can't use any of the built in formats because they will conform to the Windows setting. You'll need to make a custom format.

A mask is not used for this purpose. Masks are used to control data entry. Formats are used to control data display. Just understand that no matter which format you use for a date, dates are ALWAYS stored as serial numbers, NOT as text strings.

 

[Bachfile]

Thanks Pat, that cleared things up.

Cheers