Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date function expression with variable

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

1 Solution

Accepted Solutions
jerem1234
Specialist II
Specialist II

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!

View solution in original post

3 Replies
petter
Partner - Champion III
Partner - Champion III

Something like this?

2015-01-08 18_09_14-Greenshot.png

jerem1234
Specialist II
Specialist II

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!

Not applicable
Author

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