Variable

[#1]

  Dear,

set vLockDate2='03-Sep-2015';

I set variable and assign value as above and want to show month end in another variable but its not show value as given below variable.
LET v2LockDate=MonthEnd(vLockDate2);

kindly guide how to show value.

Regards,

Zain.

[Digvijay_Singh]

Try setting formatting, You may need to apply required format as per your need.

LET v2LockDate=Date(Date#(MonthEnd(vLockDate2),'DD-MMM-YYYY'));

[sunny_talwar · Accepted solution]

May be this:

LET vLockDate = Date#(03-Sep-2015', 'DD-MMM-YYYY');

LET v2LockDate = MonthEnd(vLockDate);

[maxgro]

LET v2LockDate=MonthEnd(Date#(vLockDate2,'DD-MMM-YYYY'));

[#5]

Thanks Sunny, i have got result.

Zain.

[alexandros17]

LET vLockDate2='03-sep-2015';

LET v2LockDate = MonthEnd(Date#(vLockDate2,'DD-MMM-YYYY')); 

[jagan]

Hi,

Try like this

LET vLockDate2= MakeDate(2015, 9, 3);

LET v2LockDate=MonthEnd(vLockDate2);

Hope this helps you.

Regards,

jagan.

[#8]

TRY LIKE THIS

LET VEND=MonthEnd(DATE(date#('$(vLockDate2)','DD-MMM-YYYY'),'DD/MM/YYYY'))