Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Could you please help me with the below scenario
I am fetching data from a folder which has month wise file which have the Salesdate and amount column, In each month the date format is different
For example, Jun has the format as DD/MM/YYYY , Jul the date would be mm/dd/yyyy,aug is YYYY/Mon/DD.
I need to change all the date foramt to dd/mm/yyyy. how to achieve this. On giving the format to the set variables doesnt help.
Thanks,
Sowmiya
Hi,
alt , can help you solve this problem :
Hi,
alt , can help you solve this problem :
If the file is suing a date field it will be a number so if you are lucky maybe justa date(FieldName) can return the date in the specied date format of the QlikView document.
If not you can't really know if 01/02/2020 is for 1-feb (DD/MM/YYYY) or for 2-jan (MM/DD/YYYY).