I have an issue with the today(). Its returning 8/8/2014. now() returns 8/7/20

karls over 10 years ago

I have an issue with the today(). Its returning 8/8/2014. now() returns 8/7/2014 7:44 PM PDT. Is there a setting I am missing. The System cal is set to PST....

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 10 years ago

Are you using just today() or you are using today() inside something else?

Since today doesn't have a time associated it will create a date time <TODAY> 00:00:00 GMT so to avoid dealing with this adjustment it would be easier to use:

=todate(local(now()))

if you're not using it inside a text function.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 10 years ago

Are you using just today() or you are using today() inside something else?

Since today doesn't have a time associated it will create a date time <TODAY> 00:00:00 GMT so to avoid dealing with this adjustment it would be easier to use:

=todate(local(now()))

if you're not using it inside a text function.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data