Convert text into date format

Certified Associate Developer

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

Parents
  • 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

Reply
  • 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

Children
No Data