Hi,
I have Start Date and End Date in my report.
I did End date - start Date so then I got 5 days. Now I ahve to add 1 to this 5 days. which format I have to use to add 1 to 5days data item.
Thanks,
Could you please explain what do you mean by 'Now I ahve to add 1 to this 5 days?
Thanks
P
Quote from: d.laxmi on 03 Jan 2011 01:32:32 PM
Hi,
I have Start Date and End Date in my report.
I did End date - start Date so then I got 5 days. Now I ahve to add 1 to this 5 days. which format I have to use to add 1 to 5days data item.
Thanks,
Hi Laxmi
according to your plan 'Now I have to add 1 to this 5 days' , do you want to one more day to the resultant days?
Then try to use this' _add_days' function
ex:_add_days()
_add_days([your resultant data item],+1)
Thanks srinivas,
with following _add_days function I am getting below error.
_add_days([your resultant data item],+1)
What I did, I have start date and end date. so using _days_between function I got the difference between the days like 3,4 etc..
Now for that number I have to add 1.
so I used _add_days([data item],+1) then got below error:
UDA-SQL-0460 A general exception has occurred during local processing.UDA-EE-0094 The operation "_add_days" is invalid for the following combination of data types: "double" and "integer"RSV-SRV-0042 Trace back:RSReportService.cpp(771): QFException: CCL_CAUGHT: RSReportService::process()
If you just want to add number to your result
you can create a dataitem like [your resultant data item] +1..
I tried above approach got the result.
Cheers
Mrcool