Does anyone know the formula to subtract 3 hours from date and time field but... show just the time please? This formula provides the correct answer showing date and time but...
DATEADD(
{Departure Date & Time},
-3,
'hours'
)
...when I add this to the formula to they and show just time -- the time is completely wrong.
DATETIME_FORMAT(
DATEADD(
{Departure Date & Time},
-3,
'hours'
),
'h:mmA'
)
My attempts have resulted in a series of #Errors. Any ideas please? Thank you.