topic Re: convert to date in QlikView

convert to date

Aldemarprins4 — Thu, 21 Jul 2022 12:57:39 GMT

Hello everyone,

I have the following field with May2022 and I want to convert it to 01/05/2022, is that possible in Qliview

Re: convert to date

Or — Thu, 21 Jul 2022 13:00:08 GMT

=Date#('May2022','MMMYYYY') should work here, I believe.

Re: convert to date

Aldemarprins4 — Thu, 21 Jul 2022 13:04:50 GMT

Hello, it doesn't work
What happens if the month changes? In other words, I am taking that month from the name of the file, but what happens when I go to June? If I leave that format, will it convert June to 05/01/2022?

Re: convert to date

hic — Thu, 21 Jul 2022 13:05:14 GMT

... and if you want it formatted as a date, you need to wrap the above expression in Date():

=Date(Date#('May2022','MMMYYYY'))
or
=Date(Date#('May2022','MMMYYYY'),'DD/MM/YYYY')

Re: convert to date

Or — Thu, 21 Jul 2022 13:11:41 GMT

What, exactly, doesn't work? "It doesn't work" doesn't give me any information about what the problem is.

You would replace the hardcoded string with your field. This was an example.

Re: convert to date

Aldemarprins4 — Thu, 21 Jul 2022 13:12:05 GMT

No still not working

Re: convert to date

sicilianif — Thu, 21 Jul 2022 13:19:01 GMT

@Aldemarprins4 If you are going to have full month names, I think you would need to do this:

=Date(Date#(Left('June2022',3)&right('June2022',4),'MMMYYYY'),'DD/MM/YYYY')

Re: convert to date

Aldemarprins4 — Thu, 21 Jul 2022 15:00:27 GMT

thank you very much it works