Help

Create Date formula, today at hours, minutes

Topic Labels: Formulas
Solved
Jump to Solution
425 1
cancel
Showing results for 
Search instead for 
Did you mean: 
GorillaDev
4 - Data Explorer
4 - Data Explorer

I want to create a formula fields equal to now() with specific hours and minutes. My formula must return a date equals to today at 18:00. 

Exemple today is 05/06/2024 16:12 -> 05/06/2024 18:00

Thanks

1 Solution

Accepted Solutions
GorillaDev
4 - Data Explorer
4 - Data Explorer

I found by myself

 

DATETIME_PARSE(
DATETIME_FORMAT(NOW(),"DD-MM-YY") & " 18:00"
)

See Solution in Thread

1 Reply 1
GorillaDev
4 - Data Explorer
4 - Data Explorer

I found by myself

 

DATETIME_PARSE(
DATETIME_FORMAT(NOW(),"DD-MM-YY") & " 18:00"
)