Date-Time Math question

Hi, I’m looking for help - is it possible to use any of the native math functions to separate the date or time from a date/time column ?

Yes, just create create a math column, type in a value, such as ‘X’, then replace it with the date column you want to use. Then set the the format to be date only or time only.


Thanks for the reply Jeff. The problem I’m facing is relating two of these columns in different sheets as they seem to retain the date/time part and don’t match.
Any workarounds without using gsheets?

Create a template columns of the date or math column and use that for your relation. Templates will “lock in” the formatting you set on the date/math column and not use the underlying date value anymore.


Great stuff! cheers

1 Like