Discussion board where members can get started with QlikView.
how can i convert DD/MMM/YYYY format into MM/DD/YYYY in QV? What would my expression look like?
ex: my date field looks like this: 02/Jun/2011 or 05/Jul/2011
The month is always 3 letters.
My set statement is SET DateFormat='M/D/YYYY' --- which i need for the other queries.
So can i use another SET statement just before running this query (which i tried and didnt work) or can i convert the format using an expression?
Hi, try this:
=date(date#('01/fev/2011', 'DD/MMM/YYYY'), 'DD/MM/YYYY')
Hope this helps.
still nothing is being displayed in the list box with the expression you provided.
i replaced it like this:
date(date#([Create Date], 'DD/MMM/YYYY'), 'DD/MM/YYYY')
[Create date] is my field where all dates are stored.
Did you check whats the date format after you have loaded the data into the QVW application?.
Anyways, I have tried using an excel(attached with this post) where I have used the date format
as your original data (for e.g. 02-Jun-11).
So when I load it in QV, it will read it as M/D/YYYY as per the set format in the main tab of the script editor.
Then(please find attached) I have formated it this way,
Say your date field is called "create date" or [create date],
Hope this helps,
Yes, i checked the format after its being loaded into qlikview. its DD/MMM/YY and now i need to convert it to MM/DD/YYYY
and my list box isnt displaying anything after trying your method.
May i ask whats your data source?. If its in email compatible format for example Excel or CSV,
will you be able to post a sample data set so that we can try.
This is what the data looks like.
i am pulling it from excel
But isn't your Create Date already in M/D/YYYY format?
Anyways if you still have problem
you can try this
As you have time stamp too, which might be causing some issue.
Here's your solution.
Also find attached the sample solution. it worked for me.