Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
see above
Hi @gustavofred , please check if this works for you :
In chart, in case of a variable :
=if(not isnull($(vDate)) and month($(vDate)) >=1 and month($(vDate)) <=12, 'date!')
or
=if(not isnull($(vDate)) and not isnull(month($(vDate)) ), 'date!')
In script, in case is a field :
Load
fields....
if(not isnull(fieldtoevaluate) and month(fieldtoevaluate) >=1 and month(fieldtoevaluate) <=12, 'date!') as flagdate
From yoursource;
Hi @gustavofred , please check if this works for you :
In chart, in case of a variable :
=if(not isnull($(vDate)) and month($(vDate)) >=1 and month($(vDate)) <=12, 'date!')
or
=if(not isnull($(vDate)) and not isnull(month($(vDate)) ), 'date!')
In script, in case is a field :
Load
fields....
if(not isnull(fieldtoevaluate) and month(fieldtoevaluate) >=1 and month(fieldtoevaluate) <=12, 'date!') as flagdate
From yoursource;