Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
Facing an issue in which the Date is in varchar format(01-Jan-20,01-Feb-2020,01-Mar-2020 & 02-Jan-20,02-Feb-2020,02-Mar-2020)for 6 months data.
For eg: as it is in varchar it is getting sorted
Date |
01-AUG-19 |
01-FEB-19 |
01-JAN-19 |
01-JUL-19 |
01-JUN-19 |
01-MAR-19 |
02-APR-19 |
02-AUG-19 |
02-FEB-19 |
02-JAN-19 |
02-JUL-19 |
02-MAR-19 |
02-MAY-19 |
03-APR-19 |
03-AUG-19 |
03-FEB-19 |
i want to make it into month/year
i have tried this:
Date(Date#(Date, 'DD/MM/YYYY ')), 'YYYY-MM-DD') as Date
Thanks in Advance
Use
Date(Date#(Date, 'DD-MMM-YY '), 'MM/DD/YYYY') as Date
Change the second expression to the format you need.
Use
Date(Date#(Date, 'DD-MMM-YY '), 'MM/DD/YYYY') as Date
Change the second expression to the format you need.