Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
date or date#
time or time#
floor to get the date only (date & time stamps are numbers in QlikView)
etc.
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')
Another Way
TextBetween('2015-07-06 10:02:19.000 +0000','','.')
SubField('2015-07-06 10:02:19.000 +0000','.',1)