Automate Date in Query Builder

Forum|Forum|9 years ago
April 25, 2016
2 replies
3142 views

I want to automate a report so that when it is run by the user, it will automatically calculate the date to use. Think of Change Notices and the need for a report to generate the results of Resolved CNs based off of the system date minus 30 days or even quarterly. This should be something that one should be able to do in the criteria section. If it can be done I haven't found it yet. The ultimate goal is to be able to set up a data monitor for management that runs on different times to give them different results automatically. Does anyone know how to do this or if it can be done?

Other

Best answer by MikeLockwood

Can use the function "System Date" and subtract 30, 60, 90 days, etc. (e.g. =System Date -30")

M

MikeLockwood

Answer

22-Sapphire I

Can use the function "System Date" and subtract 30, 60, 90 days, etc. (e.g. =System Date -30")

B

BrianToussaint

Author

19-Tanzanite

Thanks Mike! Seems I was also missing the ">=" in the condition. I just had "=".

S

STEVEG

21-Topaz I

I know this post is marked as solved but it doesn't show the actual format to use System Date. I want a report that says show me all the CN's for the last X number of days and I can't figure out how to do that. Is this how or another way? Even if this is the way, I don't know what to do from this point. Can anyone help me?