Date function / Split

[fatihsahin]

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]

date or date#

time or time#

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

etc.

[sunny_talwar · Accepted solution]

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]

Another Way

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

[sasiparupudi1]

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