Date Format in Qlikview

[Smeenakshi23]

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

[Taoufiq_Zarra · Accepted solution]

Hi,

 alt , can help you solve this problem :

• Multiple Dates Using Alt
• alt help

[rubenmarin]

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).