Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
In my data, date format is like DD-MMM-YY, ex. 31-JAN-18.
I am trying to set date picker option using master calendar in date filter,but it is not working.
Kindly help me on this.
Try
Date(Date#(INV_REPORT_DATE,'DD-MMM-YY'),'DD/MM/YYYY') as INV_REPORT_DATE
It worked. Thanks