Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Remove $ sign and try like: =date(vCreatedDate,'M/D/YYYY')
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.
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.
thanks tresesco.............
Thanks tresesco.....