We use following formulas to split date and time
Date column:
=thisRow.[Date and Time].ToDate()
Time column:
=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!
Awesome.
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
thanks.
it solves
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
