We use following formulas to split date and time
=thisRow.[Date and Time].ToDate()
=thisRow.[Date and Time].ToTime()
But what if I need to split it even further into month name, hours, minutes?
[Explanation of my use case: I have a form to fill up where the date has to be mentioned in the described format. Month, hours, minutes, AM/PM etc. I’ll be using automation to copy the values from coda doc and paste in the form.]
You are in luck.
Hour(), Date() and Minute() are gonna be your best friends!
Thanks for the prompt response.
I guess I’ll have to figure out a way to deal with month name and AM/PM column.
Oh sorry! Didn’t fully see the other aspects of your request.
If you want month name use MonthName() and if you want AM/PM just use Right(2) on your time column which simply extracts the last two characters from the column
I just finished typing switchif formula for each month number and its respective name
But good to know
January 30, 2023, 12:38pm
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.