topic Re: Date calulation in QlikView

Date calulation

Thu, 18 Feb 2016 17:27:32 GMT

I have a field called Target date

Target date

10/10/2017

Based on this date I need to calculate 3 more dates,

executed date - 60 days prior to Target date

· Approved date - 7 days prior to executed date

· Selected date - 45 days prior to Approved date

Here based on 10/10/2017,

Executed date would be - 8/10/2017

Approved date would be - 1/10/2017

Selected date would be - 11/15/2016

How can I acheive this ?

m_woolf — Thu, 18 Feb 2016 17:31:48 GMT

Something like:

date(num([Target Date])-60) as [Execute Date],

date(num([Target Date])-67) as [Approved Date],

date(num([Target Date])-112) as [Selected Date],

kaushiknsolanki — Thu, 18 Feb 2016 17:33:27 GMT

Hi Try this.

Date(TargetDate -60) for Executed Date

Date(TargetDate -60 - 7) for Approved Date

Date(TargetDate -60 - 7 - 45) for Selected Date

Regards,

Kaushik Solanki

Thu, 18 Feb 2016 17:58:13 GMT

Thank you @kaushiksolanki

and @mw...

I used the belwo script and that worked.

Date(TargetDate -60) as Executed Date

date(Date(TargetDate -60 )- 7) as Approved Date

date(date(Date(TargetDate -60 )- 7)- 45) as Selected Date

kaushiknsolanki — Thu, 18 Feb 2016 18:24:56 GMT

Great,

Kindly mark answer as correct.

Regards,

Kaushik Solanki