Input box date validation

[Anonymous]

I have created an input box which accepts dates. i need to add validation so that the user is prompted to enter dates only in MM/DD/YYYY format. Is there a way to add such validations to the inputbox like EXcel? If he enters date in any other format it still needs to be accept it as MM/DD/YYYY format

[avinashelite]

validation part i am not sure ..but you can format the variable like

vinputdate is the variable then in your calculation try like

date(vinputdate ,'MM/DD/YYYY')

[Anonymous]

Why not use a calendar object to select the dates instead?

This way the input will always be in the correct input format and range.

[Anonymous]

if i use a calendar object and select the date it appears in the number format...how do i change this..when i tried converting it in number format its not working

=date(vInputDate,'MM/DD/YYYY')

[Anonymous · Accepted solution]

Change the format under settings. Override document settings, select date and change to the format you require on the right to MM/DD/YYYY

Sent from my Samsung Galaxy smartphone.

[Anonymous]

thanks..its working now