Category
Report Builder
Product Version
9.0
How to add weeks to a date
Awaiting Reply
Hello,
I am trying to add a new column where I want to show that if the grade is not been posted 6 weeks after the event was finished, it should show as Late Submission of the grade. The current event finish date column format is shared in the picture below.
How do I add create a new date column with 6 weeks plus date? I not able to understand how to create a new column where I can add 6 weeks to the event_finish column.
The same question
Hi Rushil,
Thanks for submitting a question to Yellowfin and I hope you're doing well.
So usually you would want to use this to display data that matches the criteria as shown again the value in the date column.
You can create filters that will dynamically use the current date and you can then add or subtract quantities of days, weeks, months or years from that, like below:
Is that what you are looking for?
However, for your scenario, it looks like you want to do a bit of a calculation where it counts the days between the event start and submission date and if that is greater than 6 weeks, then you get a late submission, is that what you mean? A calculated field might be a better bet in that case, but you will need a column that contains both pieces of data.
Kind regards,
Chris
Hi Rushil,
Thanks for submitting a question to Yellowfin and I hope you're doing well.
So usually you would want to use this to display data that matches the criteria as shown again the value in the date column.
You can create filters that will dynamically use the current date and you can then add or subtract quantities of days, weeks, months or years from that, like below:
Is that what you are looking for?
However, for your scenario, it looks like you want to do a bit of a calculation where it counts the days between the event start and submission date and if that is greater than 6 weeks, then you get a late submission, is that what you mean? A calculated field might be a better bet in that case, but you will need a column that contains both pieces of data.
Kind regards,
Chris
I want to add 6 weeks from the event_finish column to show me a new date with a new column. And then use that column to create a case statement in calculated field to show if the grade is not submitted beyond the 6 weeks. I am struggling to create the new column where I add 6 weeks and it shows me a new date after 6 weeks in calculated field.
I want to add 6 weeks from the event_finish column to show me a new date with a new column. And then use that column to create a case statement in calculated field to show if the grade is not submitted beyond the 6 weeks. I am struggling to create the new column where I add 6 weeks and it shows me a new date after 6 weeks in calculated field.
Hi Rushil,
While there isn't a feature that can take a timestamp and an arbitrary amount of time to it, it should be possible to accomplish using Freehand SQL calculated fields. For example, if you are using SQL Server, there is the DateAdd() function, as explained here: https://www.w3schools.com/sqL/func_sqlserver_dateadd.asp which should work within Freehand SQL fields. I hope that helps!
If you're not using SQL Server and can't find a similar expression, we could look at creating an enhancement request.
Kind regards,
Chris
Hi Rushil,
While there isn't a feature that can take a timestamp and an arbitrary amount of time to it, it should be possible to accomplish using Freehand SQL calculated fields. For example, if you are using SQL Server, there is the DateAdd() function, as explained here: https://www.w3schools.com/sqL/func_sqlserver_dateadd.asp which should work within Freehand SQL fields. I hope that helps!
If you're not using SQL Server and can't find a similar expression, we could look at creating an enhancement request.
Kind regards,
Chris
Hi Rushil,
Hope you're having a good week.
Just wanted to check-in and see how it's all going. Is there anything you are needing from me to help get this resolved?
Kind regards,
Chris
Hi Rushil,
Hope you're having a good week.
Just wanted to check-in and see how it's all going. Is there anything you are needing from me to help get this resolved?
Kind regards,
Chris
Replies have been locked on this page!