topic Date function expression with variable in QlikView

Date function expression with variable

Thu, 08 Jan 2015 16:40:37 GMT

Dear all,

I have a variable "vDateFunction" with the following expression:

= date(yearstart(makedate(((($1 - fmod($1,1000)) / 1000) + 1900))) + (fmod($1,1000) - 1))

Now I want to use this variable and fill in a date field ([Date - Beginning Effective]") at the $1:

=$(vDateFunction(=[Date - Beginning Effective]))

but it doesn't work.. I have tried a lot of different alternatives but I just don't get it working!

Any thoughts?

Thank you in advance!

Regards,
Marcel

petter — Thu, 08 Jan 2015 17:11:26 GMT

Something like this?

jerem1234 — Thu, 08 Jan 2015 17:11:41 GMT

Did u try taking the equal sign out of your variable definition:

date(yearstart(makedate(((($1 - fmod($1,1000)) / 1000) + 1900))) + (fmod($1,1000) - 1))

Then see if it works.

Hope this helps!

Sun, 11 Jan 2015 19:55:19 GMT

Yes, you're absolutely right... just remove the = sign in the variable... did not think of that! So thank you very much!