Skip to Content
0
Former Member
Mar 21, 2011 at 04:22 PM

Prompt in dd/mm/yyyy format

2469 Views

Hi,

I need to accept data from user in dd/mm/yyyy format, but as of now the default format what the prompt is taking is mm/dd/yyyy.

Considering the prompt as 'Date from'. Kindly help me out with the code for dd/mm/yyyy.

As of now the query is MRK.Data.From_Date=@Prompt('Date from','D',,,).

Thanks.

Jim