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

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.



Sun Mar 29, 2015 3:12 PM

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:


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:


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

Kind Regards,


Best regards,

The Yellowfin Support Team

Contact Us:
Community Forum:


Tue Mar 31, 2015 9:18 AM