I’m trying to extract the hour from a datetime column. When I use datetime_format(field('date'), 'HH')
it seems to extract the AM time of a 24hr entry.
EXAMPLE:
FORMULA: datetime_format(field('date'), 'HH')
Any ideas or a better way to extract the hour?
My end goal is to have a column say true or false if the time is between 00:00 and 06:00.
Thanks!