Discussion board where members can get started with Qlik Sense.
I have loaded a series of dates below.
How can I convert them into DDMMYY format? I've seen a few suggestions online but wasn't able to get it working... thanks for your help!
Are these column names? Are you cross-table loading them?
If they are column names and you not cross table loading them, and if you know the min and max dates, you could create a mapping table, and rename the fields using the mapping table. For example:
RecNo() + 42157 As DateNum,
Date(RecNo() + 42157) As Date
Autogenerate (42214 - 42158 + 1);
Rename Fields using MapNames;
Hi Jonathan, sorry I should have mentioned that the dates are crosstabled.
juz use Date(fieldnme,'DDMMYYYY')
That doesn't work... Sales Agent is not a date field...
Like this then:
LOAD [Sales Agent],
Date(Date) As Date,
DROP TABLE T_Data;
If Date(Date) is not giving the format you desire, then use something like Date(Date, 'DDMMYY') to get the format you require.
Hmm.. I've tried your suggestion, but I still get dates in format like 42158, for example. Any suggestion?
Try like this:
date(trim(replace([Sales Agent],'"','')),'MMDDYY') as New field
Hi Jyotish and Allen,
Allen saying that Sales Agent is not the Date field, i advice him to replace it by Date field on your code. I hope it helps him.