Not able to set data picker in date filter due to the date format

[swetha54]

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.

[shiveshsingh · Accepted solution]

Try

Date(Date#(INV_REPORT_DATE,'DD-MMM-YY'),'DD/MM/YYYY') as INV_REPORT_DATE

[swetha54]

It worked. Thanks