Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
How can I get date from text in format 'MMM D, YYYY'?
For instance:
Apr 1, 2014
Apr 12, 2014
Thanks in advance
=date(date#('Apr 1, 2014', 'MMM DD, YYYY'))
you can use a text box with previous expression to check it and try different format
in the script
load
.....
date(date#(yoursourcedatefield, 'MMM DD, YYYY')) as DateField,
,,,,,,,,,,,,,
detailed explanation here
=date(date#('Apr 1, 2014', 'MMM DD, YYYY'))
you can use a text box with previous expression to check it and try different format
in the script
load
.....
date(date#(yoursourcedatefield, 'MMM DD, YYYY')) as DateField,
,,,,,,,,,,,,,
detailed explanation here
Try this:
Date(Today(),'MMM dd,yyyy')
--Jai
How is your actual date format?
considering you have datefield in 'DD/MM/YYYY'
you can convert 'DD/MM/YYYY' to 'MMM D, YYYY' as below
Write below in your script...
Date(Date#(DateField, 'DD/MM/YYYY'),'MMM D, YYYY') as DateField
Thank you, but I don’t think my question was clear.
I receive files with dates in 'MMM D, YYYY' format, but QlikView doesn't treat it as date, I'd like to format it in regular date
Date(Date#(DateField, 'MMM D, YYYY')) as DateField
Ok, then try this:
Date(<Your Date Field>,'MM/DD/YY') as Date
There is a space before date in files. So, your formula works with this correction. I didn't mention this space
Date(Date#(DateField, ' MMM D, YYYY')) as DateField
Thank you