current date + 30 days
29 March, 2015
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
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.
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
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