Date function expression with variable

[#1]

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]

Something like this?

[jerem1234 · Accepted solution]

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!

[#4]

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