Jason_Peterson - profile

Jason_Peterson · Jun 27, 2019

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!

Jason_Peterson · Jun 28, 2019

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}, "...

Jason_Peterson · Jun 28, 2019

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...

Jason_Peterson · Jun 28, 2019

Justin Thanks so much! This is exactly what I needed and thanks for explaining it to me! Perfect!

User Statistics

User Activity

IF Date field is after a certain time do this

Re: IF Date field is after a certain time do this

Re: IF Date field is after a certain time do this

Re: IF Date field is after a certain time do this