Converting Time from hours and minutes to decimal ...

[GorillaDev]

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

[GorillaDev · Accepted solution]

I found by myself

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