Skip to main content
Solved

Create Date formula, today at hours, minutes

  • May 6, 2024
  • 1 reply
  • 19 views

Forum|alt.badge.img+5

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

Best answer by GorillaDev

I found by myself

 

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

1 reply

Forum|alt.badge.img+5
  • Author
  • New Participant
  • Answer
  • May 6, 2024

I found by myself

 

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