Forum

This content is now out of date.

Visit Our Community

current date + 30 days

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
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.


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:

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

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.