topic Re: Date stamp conversion in QlikView

Date stamp conversion

Wed, 25 Nov 2020 16:16:04 GMT

Hi, I'm battling to convert this raw data into a normal date.

here is an example of the date stamp (CreatedDate field) import: "2015-06-11T09:45"

I want to convert this to just the normal date like this: "2015/06/11".

Please assist with syntax for this.

Many thanks

Re: Date stamp conversion

sunny_talwar — Mon, 07 Mar 2016 20:50:08 GMT

Try this:

Date(Date#(Left(CreatedDate, 10), 'YYYY-MM-DD'), 'YYYY/MM/DD') as Date

Re: Date stamp conversion

Tue, 08 Mar 2016 03:09:37 GMT

Perfect! Thanks

Re: Date stamp conversion

jagan — Tue, 08 Mar 2016 03:37:22 GMT

Hi,

You can also try like this

LOAD

MakeDate(SubField(CreatedDate, '-', 1), SubField(CreatedDate, '-', 2), SubField(CreatedDate, '-', 3)) AS Date

FROM DataSource;

Hope this helps you.

Regards,

jagan.

Re: Date stamp conversion

HirisH_V7 — Tue, 08 Mar 2016 04:00:48 GMT

Hi,

Check this,

Replace(SubField(Field,'T',1),'-','/')

HTH,

Hirish

Re: Date stamp conversion

senpradip007 — Tue, 08 Mar 2016 04:25:21 GMT

Try like:

date(Timestamp#(replace(CreateDate, 'T', ' '), 'YYYY-MM-DD hh:mm'), 'YYYY/MM/DD') as NewDate

Re: Date stamp conversion

tamilarasu — Tue, 08 Mar 2016 04:49:34 GMT

Also try,

Date(Date#(PurgeChar(CreatedDate,'T'),'YYYY-MM-DDhh:ss'),'YYYY/MM/DD')

Date(Date#(Replace(CreatedDate,'T',''),'YYYY-MM-DDhh:ss'),'YYYY/MM/DD')

Re: Date stamp conversion

engishfaque — Tue, 08 Mar 2016 05:17:02 GMT

Dear Manus,

Here is a script for timestamp conversion

Table1:

LOAD *, Date(Left(Date, Index(Date, 'T') - 1), 'YYYY/MM/DD') as newDateField Inline [

Date

2015-06-11T09:45

];

For more detail, kindly find attached App.

Kind regards,

Ishfaque Ahmed

Re: Date stamp conversion

oknotsen — Tue, 08 Mar 2016 09:10:11 GMT

If your question is now answered, please flag the Correct Answer and optionally Helpful Answers.

If not, please make clear what part of your question you still need help with .