Why is the DATEONLY formula outputting future dates?

Hector Mendez

Any time stamp after 7pm will be counted for the following date. Please see snapshot below. The time stamp is auto generated when the user fills out a form.

Paul Newcome

It is because of timezones. You are going to need a formula that grabs the hour, searches for "PM" and then subtracts 1 for anything greater than 7pm.

It will look something like this...

=DATEONLY(Created@row) - IF(AND(FIND("PM", Created@row) > 0, VALUE(SUBSTITUTE(MID(Created@row, 10, 2), ":", "")) > 7), 1, 0)

Paul Newcome

It is because of timezones. You are going to need a formula that grabs the hour, searches for "PM" and then subtracts 1 for anything greater than 7pm.

It will look something like this...

=DATEONLY(Created@row) - IF(AND(FIND("PM", Created@row) > 0, VALUE(SUBSTITUTE(MID(Created@row, 10, 2), ":", "")) > 7), 1, 0)