How to use date dynamically??

[soha1902]

Hi All,

During Load, I am using below statement

-------

-------

if

(len(Deactivated)>1,Deactivated,'01/30/2017') As NewDeactivated

--------

--------

It is working fine without any issue. But If I used below statement

let

vMax= '01/30/2017';

Table:

Load

----------------

----------------

if

(len(Deactivated)>1,Deactivated,$(vMax)) As NewDeactivated

--------

--------

Then it is not showing correct value for else part. Please help me to solve this.

Thanks.

[tresesco · Accepted solution]

Try putting the variable within quotes like:

if

(len(Deactivated)>1,Deactivated,'$(vMax)') As NewDeactivated