Date format dd.mm.yyyy

[Troopa]

Hi, what's the best way to allow a user to enter the date format with periods in between day month and year?

When the users use the number pad to enter the date they want to do it with period instead of slashes etc but when they do this the date defaults to 30 December 1899

the format is currently set to long date.

thanks in advance

 

[PHV]

Why not having the slashes in the input mask ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Troopa]

that would be the easiest option for me but that would still require the user to use the slashes and they want to use the period (if at all possible)

 

[ProgramError]

Then you need code to truncate the input and substitute the periods for slashes. Use the dd.mm.yyy to display the date or even dd-mm-yy.


Ian Mayor (UK)
Program Error
There's ALWAYS more than one way to skin a cat!
But only one way to get it RIGHT!