Page 1 of 1

Get Today's Date?

Posted: Thu Feb 11, 2016 9:59 pm
by jp2code
How do I get "today's date" for a default parameter in a report?

Re: Get Today's Date?

Posted: Fri Feb 12, 2016 12:40 pm
by HighAley
Hello, Joe.

You should use Today system variable.

Thank you.

Re: Get Today's Date?

Posted: Fri Feb 12, 2016 4:02 pm
by jp2code
How would I use that?
Error Setting Key
Error Setting Key
getgreenshot_org.jpg (139.79 KiB) Viewed 7358 times

Re: Get Today's Date?

Posted: Sat Feb 13, 2016 11:59 pm
by Jan
Hello,

Please create item value with the help of the New Expression button!

Please check attached image.

Let me know about the results!

Thank you.

Re: Get Today's Date?

Posted: Mon Feb 15, 2016 8:26 pm
by jp2code
It would have taken me a long time to have guessed that.

So, now I know how to set my default "End Date" search.

Our default "Start Date" search parameter is supposed to be 30 days before this.

How would I specify 30 days before {Today}? Would I use some combination of "-Today- -30" or "DateSerial(-Today-.Year, -Today-.Month - 1, -Today-.Day)"?

Re: Get Today's Date?

Posted: Mon Feb 15, 2016 10:52 pm
by Jan
Hello Joe,

Sorry for the misunderstanding. "-Today-" is a how this value will be displayed for the customer. You can use any string for this field.
You can use the following expression to get date time + 30 days:

Today.AddDays(30)

Thank you.