NOW() and GET_DATETIME_COMPONENT compatibility

There are two variables.

The first is the current datetime that is set with the formula NOW().
The second is the date extracted from NOW() using the formula GET_DATETIME_COMPONENT(NOW(), “date”).

The results are inconsistent.

The first date variable produces a value of 09/19/2021

The second variable produces a value of 20.

Is this a bug or am I doing it wrong?

Hi Jim,

the formula is OK and working right. Today is the 20th of September.

The only thing I can think of is that you are in a different timezone, than NOW() is anticipating.
You can check this with LOCAL_TIMEZONE().