This content is now out of date.

Visit Our Community

current date + 30 days


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.

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.

Forum image

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: