How to add a number of days to a converted date field?
8 August, 2012
I had a quick question on a column in a read-only database.
I am pulling from for a dashboard.
The date field is measured in number of days from Dec. 28, 1800. I would like to convert this to a more user-friendly form, and be able to select certain data dynamically between certain dates.
Does Yellowfin have any sort of conversion tools for something like this (date(12/28/1800) + num_days)? If not, can you recommend the best way to go about this?
Thank you.
Hi,
It is possible to run free-hand SQL queries in the Yellowfin view builder, so you can do your conversions there.
If you were using SQL server, and wanted to add a number of days to a date field, you would just use the following calculation ;
[code]
DateAdd(d, 5, date)
[/code]
Where date is my actual field name.
Please let me know if this doesn't give the results you were after.
Regards,
David
It is possible to run free-hand SQL queries in the Yellowfin view builder, so you can do your conversions there.
If you were using SQL server, and wanted to add a number of days to a date field, you would just use the following calculation ;
[code]
DateAdd(d, 5, date)
[/code]
Where date is my actual field name.
Please let me know if this doesn't give the results you were after.
Regards,
David
You can also try custom function
Regards
Rahul
Regards
Rahul