topic Re: need makedate help in QlikView

need makedate help

ananyaghosh — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am using the makedate function like this:

MakeDate(Year(AddYears(Max([Process Date])-1,-5)), num(month(AddYears(Max([Process Date])-1,-5))), num(Date(Max([Process Date])-1,'DD')) )

and it does not work.

My maximum process date is : 09/15/2017, so the output should be 09/14/2012.

When I add this to makedate function:- num(Date(Max([Process Date])-1,'DD'))

it does not work.

but when I use this below:-

MakeDate(Year(AddYears(Max([Process Date])-1,-5)), num(month(AddYears(Max([Process Date])-1,-5))), 14)

it works fine.

swuehl — Wed, 04 Oct 2017 07:48:08 GMT

Use

Day(Max([Process Date])-1)

swuehl — Wed, 04 Oct 2017 07:49:05 GMT

And what about this (not using Makedate() at all)

Date(AddYears(Max([Process Date])-1,-5),'MM/DD/YYYY')

Kushal_Chawda — Wed, 04 Oct 2017 07:49:11 GMT

only this should work

addyears([Process Date],-5)-1

addyears(max([Process Date]),-5)-1