Current_date column is not displaying as required.

[#1]

Hi All,

I am working on Incremental load report i have created one variable that contains(created_date,-1) by using peek() function and i dragged that column into report screen by using text object.current_date column is displaying as required.

I have attached my script.

Please let us know how to proceed.

[tresesco]

Remove $ sign and try like: =date(vCreatedDate,'M/D/YYYY')

[#3]

yes it works, tresesco

but still i am not aware of the logic behind this remove dollar sign from variable that is being used in TEXT OBJECT

Generally what we do , we always access the variable having syntax like $(var_name)

can u explain lil bit.

[tresesco]

Sure.

If you just take the variable without $, you will see it coming like - 1/8/2015 . This variable is already evaluated in the script and got a value assigned. Now if you try to expand this using $ , it will evaluate the value it self, i.e - 1/8/2015.

That means it will first evaluate 1/8=0.125 and then 0.125/2015=0.0000620..

And then effectively Date(0)->12/30/1899  the starting date.

Basically a numerical evaluation of 1/8/2015   where '/' is division symbol. Hope this helps.

[#5]

thanks tresesco.............  

[#6]

Thanks tresesco.....