Hello,
I am trying to convert a date-time field to a previous version of it. I have thousands of records of one date time format and then it recently got changed to a different format.
Here's the original date-time that I was receiving:
="2021-12-03 07:19 AM"
And now I'm getting it like this:
Mon, Dec 06, 2021 10:31 AM
Is there a formula that I can use to easily convert the newer date-time entry to the previous one? Any help would be greatly appreciated. Thank you!
I am trying to convert a date-time field to a previous version of it. I have thousands of records of one date time format and then it recently got changed to a different format.
Here's the original date-time that I was receiving:
="2021-12-03 07:19 AM"
And now I'm getting it like this:
Mon, Dec 06, 2021 10:31 AM
Is there a formula that I can use to easily convert the newer date-time entry to the previous one? Any help would be greatly appreciated. Thank you!