How to make the date stay the exact date

tchav

Hello if something is typed in after 5:00pm, my date goes to the next day. How do i change this ?

Paul Newcome

Try this:

=DATEONLY(Created@row) - IF(AND(VALUE(MID(Created@row, FIND(":", Created@row) - 2, 2))>= 5, VALUE(MID(Created@row, FIND(":", Created@row) - 2, 2))< 12, FIND("PM", Created@row)> 0), 1, 0)