Date formula question

[natetc]

Hi all,

My question is how do I create a date/time formula that runs for the current/yesterdays business day. I want the formula to pick up data from yesterday 3pm to today 3pm. This is the formula I have in the system now:

{ABC.EVENT_DATTIM} in DateTime (2010, 10, 27, 15, 00, 00) to DateTime (2010, 10, 28, 15, 00, 00)

So the goal is to have "2010, 10, 27" to change, first date is yesterday and second date is today.

Any thoughts?
Thanks!

 

[briangriffin]

Yesterday 3:00:

dateadd("h",15,currentdate - 1)

Today 3:00:

dateadd("h",15,currentdate)

However, if you're using a range you should probably subtract a minute from the today calculation:

dateadd("n",899,currentdate)

gives you today at 2:59 pm.

 

[natetc]

Thank you briangriffin