This forum is now out of date, for our new forum Click Here
current date + 30 days
Question Asked
Hi,

Im sure this is quite simple but I dont seem to be able to figure it out.

I want to be able to display a calculated field in my report that is based on current date + 30 days.

I figure it needs to be a calculated field. I need to use the current date somehow and add 30 days to it.

Any help much appreciated. Database is postgres if that helps.

Peter

Peter

Sun Mar 29, 2015 3:12 PM

Answer
Hi Peter,

I think what you are looking for is the Dateadd() SQL function. You will need to create a calculated field or use the free hand SQL report builder to do this.

The syntax is this:

DATEADD('day',30,YourDateField)

Take a look at the below screenshot of an example of how to build it. I used the Yellowfin Ski Team database to set this up.





Also, here is a link to the DATEADD() function:

SQL Server DATEADD() Function

And in case you haven't seen it here is a guide to our wiki surrounding calculated fields:

Calculations

Hopefully this helps answer your question. Please let me know if you have any other questions/concerns!

Kind Regards,

Dustin

Best regards,

The Yellowfin Support Team

Contact Us:
Email: support@yellowfin.bi
Wiki: wiki.yellowfin.com.au/display/USER71/Home
Community Forum: www.yellowfinbi.com/YFForum.i4

Dustin

Tue Mar 31, 2015 9:18 AM