convert to date

[Aldemarprins4]

Hello everyone,

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

[Or]

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

[Aldemarprins4]

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?

[hic · Accepted solution]

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

[Or]

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.

[Aldemarprins4]

No still not working

[sicilianif · Accepted solution]

@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')

[Aldemarprins4]

thank you very much it works