topic Re: Date function / Split in QlikView

Date function / Split

fatihsahin — Mon, 13 Jul 2015 12:59:00 GMT

Hi.

How to split this into date and time:

2015-07-06 10:02:19.000 +0000

I do not need the ending 000 +0000

Regards

giakoum — Mon, 13 Jul 2015 13:00:39 GMT

date or date#

time or time#

floor to get the date only (date & time stamps are numbers in QlikView)

etc.

sunny_talwar — Mon, 13 Jul 2015 13:01:31 GMT

Try this:

Date:

=Date(Floor(TimeStamp#(Left('2015-07-06 10:02:19.000 +0000', 19), 'YYYY-MM-DD hh:mm:ss')), 'YYYY-MM-DD')

Time:

=Time(Frac(TimeStamp#(Left('2015-07-06 10:02:19.000 +0000', 19), 'YYYY-MM-DD hh:mm:ss')), 'hh:mm:ss')

robert_mika — Mon, 13 Jul 2015 15:13:46 GMT

Another Way

TextBetween('2015-07-06 10:02:19.000 +0000','','.')

sasiparupudi1 — Mon, 13 Jul 2015 18:26:33 GMT

SubField('2015-07-06 10:02:19.000 +0000','.',1)