Hi All,
In my report I'm sorting data by a column named A_DATE.We pick the data from text file and hence the column is fetch as Character column. The format of the column is 'mm/dd/yyyy'. I want to sort the data dynamically on this column but considering it as a date. I need to format it as 'yyyy/mm/dd' before sorting as this will be the correct way of sorting. I can use :
ORDER BY Format(A_DATE,'yyyy/mm/dd')
but this won't work on UNIX.
Any other suggestions?
In my report I'm sorting data by a column named A_DATE.We pick the data from text file and hence the column is fetch as Character column. The format of the column is 'mm/dd/yyyy'. I want to sort the data dynamically on this column but considering it as a date. I need to format it as 'yyyy/mm/dd' before sorting as this will be the correct way of sorting. I can use :
ORDER BY Format(A_DATE,'yyyy/mm/dd')
but this won't work on UNIX.
Any other suggestions?