Date time, tomorrow, report

[Russ]

Hey community!

Any thoughts on how to pull in the report, all deals with cXYZFeildTimeStampt = tomorrow?

I guess I have to use formula, or 'having' expressions, any help us appreciated.

I tried cXYZFeildTimeStampt is next 1 days but depending on the time of the day it pulls records for tomorrow and day after tomorrow

Thank you!

[lazovic]

Hi Russ,

Please try to use the following filters in your report (in the filter section, add Complex Expression; instead of the Close Date field, select the field you need):



Formula scripts for these filters:

datetime\date(datetime\addDays(datetime\now(), 1))

datetime\month(datetime\addDays(datetime\now(), 1))

datetime\year(datetime\addDays(datetime\now(), 1))

[yuri]

Note that the DATE won't apply the system time zone. It will give UTC tomorrow.

I'd recommend not using DATE, but add two filters. "dateTimeField >= tomorrow_start" and "dateTimeField < day_after_tomorrow_start".

tomorrow_start and day_after_tomorrow_start are supposed to be defined with a formula expression.

[Russ]

thank you all!