Hey Team (I’ll tag @TRB-monday.com) ,
I’m attempting to create a workaround for not having a datetime reminder. The way I’m doing this is with a time intelligence formula which will be tied to a notification automation.
I’m working up to the logic by first understanding if I can extract the hour from the times I need for the logic and then I’ll create the reminder column.
But I’m having issues with the HOUR() operator on two different instances:
- With a datetime column, the HOUR() extraction from the datetime is not precise.
Please note the image below where the hour from the column is 5:00PM, yet the extraction gives out the number 11.
- With an hour column. The HOUR() extraction from the hour says I’m missing parameters.
There is no documentation on how the HOUR() formula works, I’m tempted to say there is an issue with the casting on the operator itself, but hopefully I’m wrong and someone can point me in the right direction!
Thanks and all the best,
Nico from DBCC