Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have the following field with May2022 and I want to convert it to 01/05/2022, is that possible in Qliview
... 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')
@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')
=Date#('May2022','MMMYYYY') should work here, I believe.
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?
... 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')
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.
No still not working
@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')
thank you very much it works