This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi,
I am looking for a way to build a formula that goes like this
If the date created+timestamp <= to 4PM that day then subtract 10 hours if not subtract nothing.
I am racking my head how to do this. Any help would be awesome!
Got It. :grinning:
This below worked. just did a nested if.
Thanks again for getting me on the right path
DATETIME_FORMAT(
IF(
VALUE(
DATETIME_FORMAT(
{Date Created},
"...
As it goes I asked for something that does not quite incompass what I want.
What I now realize I need is subtract 10 hours if date created is between 4pm to 7am the following day.
Building on what was given to by Justin above I did this, but somethin...