Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
When i have defined variable as : Let vEndDate = Date(Today(), 'YYYY-MM-DD') ;
and using it as: Date($(vEndDate), 'YYYY-MM-DD') , it is giving me : 1905-06-27 as output. Can someone explain me this absurd behavior?
I ahve attached application also.
Thanks
the vEndDate is already haviing a formatted date as per your let statement and you do not need to use the date function again.
use the variable directly
vEndDate
or
'$(vEndDate)'
hth
Sasi
Hi Nikhil,
You have to lose the $ in the formula.
Try the following:
Date(vEndDate, 'YYYY-MM-DD')
The LET command assigns a value to the variable.
The SET command defines the variable.
As such, the formula with $ would only work if you used the SET command instead of the LET.
Best wishes,
Susana Silva
the vEndDate is already haviing a formatted date as per your let statement and you do not need to use the date function again.
use the variable directly
vEndDate
or
'$(vEndDate)'
hth
Sasi
Hi Nikhil,
Your vEndDate will be stored in date format itself. Why u need to convert it again to date format?
Thanks,
Partha Kulkarni
Hey,
'$(vEndDate)' is working cool but vEndDate will give error bcoz it will treat it as a field.