topic Re: Date Conversion in QlikView

Date Conversion

ramanarayan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Sunny Talwar/Experts,

I have the month/year in the following format in the raw data that i load. I need help with a formula which should pick the max of the Month_Year. since the data is not in the specified format, date function is not working.

Please help.

Appreciate your support

Thanks,

Ram

Re: Date Conversion

olivierrobin — Mon, 14 May 2018 08:46:41 GMT

hello

I would try something like :

=max(date(date#(Month_Year,'MMM''YY'),'MM/YYYY'))

Re: Date Conversion

jaumecf23 — Mon, 14 May 2018 08:52:44 GMT

Hi,

Try this formula:

=Date(max(Date#(Month_Year,'MMM'&Chr('39')&'YY')),'MM/YYYY')

Re: Date Conversion

ramanarayan — Mon, 14 May 2018 08:53:50 GMT

Thank you Olivier. Perfectly works

Appreciate it

Re: Date Conversion

jonathandienst — Mon, 14 May 2018 08:58:53 GMT

=Date(Max(Date#(Month_Year, 'MMM''YY')), 'MM/YYYY')

Although these would be simpler if they were converted to dates when loaded

LOAD ....

Date#(Month_Year, 'MMM''YY') as Month_Year,

...

Re: Date Conversion

ramanarayan — Mon, 14 May 2018 09:29:45 GMT

Thank you Jonathan. This also works