topic Re: Date Format in Qlikview in QlikView

Date Format in Qlikview

Smeenakshi23 — Sat, 16 Nov 2024 00:22:08 GMT

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

Re: Date Format in Qlikview

Taoufiq_Zarra — Tue, 07 Jul 2020 10:39:42 GMT

Hi,

alt , can help you solve this problem :

Re: Date Format in Qlikview

rubenmarin — Tue, 07 Jul 2020 16:12:25 GMT

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