Hi,
I am trying to calculate a start date and time from two separated columns but I can’t get it to work with a math column.
So the top one should be 27/09/2024:15:00:00
Thanks
Hi,
I am trying to calculate a start date and time from two separated columns but I can’t get it to work with a math column.
So the top one should be 27/09/2024:15:00:00
Thanks
When you set the configuration of your “Date” column to “Date & Time” and short, you’ll see that there is more to a date column than one might see. A “Date” column type is a timestamp with date and time already included. You would need to take this into account when doing timestamp math.
It could be useful to convert the timestamp to an integer, do math on the integer, then convert that back to a timestamp. The forum is well documented on this approach, @Darren_Murphy covers this often.
Thanks, I’ll take a look
Yeah… 2 approaches.
combine the two strings with a template column, then use a text to date column to convert to a date.
Subtract the time from the date, then add the time as a fraction of a day. Sometimes you’ll still end up with fractional time since you can’t touch the milliseconds of the datetime value, but it will be pretty close
great thanks