Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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')
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.
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')
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.
thanks..its working now