Previous Date From Given Date

[vijayit43]

if i have select from date '15 aug 2014' and to date'25 Aug 2014' then days diff 10 i want to previous 10 days date from 15 Augest(5 Aug 2014) how to do that Please help.

[ajaykumar1]

Hi,

Try like ;

Load * inline

[period

08/11/2014

];

text object :date((date(period)-10)) and output is 8/1/2014

Regards,

Ajay

[PrashantSangle · Accepted solution]

Hi,

Create One Variable

varDaysDiff

Expression=

Interval(to_date-star_date,'D')

Then use that variable whereever you want that difference

Like if you want to show in text objec

Then write expression like

=Date(start_date-varDaysDiff)

Regards

[muniyandi]

Hi Vijay,

Try this expression:

Variable1 = First Date (15/Aug/2014)

Variable2 = Last Date (25/Aug/2014)

Variable3 = Date(Varaiable1-(Varaiable2 -Varaiable1 ) )

Thanks,

Muni

[#5]

Add a extra field in the script which will store Numeric value corresponding to date.

And then use that field to go to and fro in dates..

Thanks,

Singh