Date format on Form

[onenessboy]

Hi,

I have created a form on which 3 fields one is Date, collection amount and flag..

Now i Want Date should be stored in "dd-mon-yyyy" format and user should be able to enter this date field like "dd/mm/yy" (input mask)



How to specify the input mask for dd/mm/yy" and in format mask dropdown only i am seeing 5 options but i need dd-mon-yyyy" format for saving...

any inputs please
thanks in advance

[Rainlover]

Dates, regardless of format are always stored the same way.

They are stored as a decimal eg 5678936.75 not as dd-mon-yyyy

You can then display the date in the Format of your choice, but it will still be stored as a date.

[onenessboy]

Hi

Thanks for reply..

i dont bother the way date stores in db

But when user entering the date on Date field on form while data entry..it should allow him to accept "dd/mm/yy" format..

what setting i need to change..

Pls help

[Rainlover]

Change the Format in Table design to

mm/dd/yyyy

[onenessboy]

hi,

i changed the format at table level to dd/mm/yyyy. that is fine..

actually i want to allow user to enter

for example : for 17th December,2010.. my form should allow him to enter like 17122010 (i.e ddmmyyyy) format

how to acheive it..