Convert text into date format

purushottamkumar

Certified Associate Developer

4 months ago

as per the requirement,

I have to convert user texts into DB date format

Required format: YYYY/MM/DD

expected date inputs:

Date with Month Name	March 20, 2023
DD/MM/YYYY	02/12/2022
MM/DD/YYYY	12/20/2022
D/M/YYYY	3/9/2022

Discussion posts and replies are publicly visible

Top Replies

Dave Lewis 4 months ago +1 suggested
Certified Lead Developer

Is 02/12/2022 February 12, or December 2? You literally do not have any way to tell either Appian or the database which it is unless you give up one of the expected input formats or require the user to...

Parents

0 dianah3775 4 months ago

Convert text dates by using the DATEVALUE function
Enter =DATEVALUE(
Click the cell that contains the text-formatted date that you want to convert.
Enter )
Press ENTER and the DATEVALUE function returns the serial number of the date that is represented by the text date.

Regards,

Will
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Reply

0 dianah3775 4 months ago

Convert text dates by using the DATEVALUE function
Enter =DATEVALUE(
Click the cell that contains the text-formatted date that you want to convert.
Enter )
Press ENTER and the DATEVALUE function returns the serial number of the date that is represented by the text date.

Regards,

Will
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Children

No Data