Help - Timestamp

[joris_lansdaal]

Hi all,

in several logfiles I encounter the following Timestamp '20160421T102714.000+0200'.

Currently I have: SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]';

The problem I have is that I can't convert it to Date, Week, Month... as a matter of fact I can't use it at all.

Any suggestions?

[joris_lansdaal]

I do have a solution by breaking up the timecode. Like,

Month(Date#(Left(Timestamp,8),'YYYYMMDD')) as Month.

But I am curious in what rooky misstake i'm making.

[sunny_talwar]

True, would you be able to share the script you used??

[joris_lansdaal]

Here's the QVW.

When I ran the original from the server it worked fine (I found this QVW inside the community. Then I copied the content to document and further wanted to developed it, colors etc; because i have a personal edition.

The only thing bothering me is that timestamp....

[sunny_talwar]

I was not able to find TimeStamp field, but there was EventsTimeStamp field. Check this:

=Date(Floor(TimeStamp#(Left(EventsTimestamp, 15), 'YYYYMMDDThhmmss')))

[joris_lansdaal]

Amazing.........

[joris_lansdaal]

The field Timestamp is dropped in the Time Tab

[sunny_talwar · Accepted solution]

Could be the version issue. What about this:

=Date(Floor(TimeStamp#(PurgeChar(Left(EventsTimestamp, 15), 'T'), 'YYYYMMDDhhmmss')))

[joris_lansdaal]

THANK YOU!

[joris_lansdaal]

Thanks for helping me out. Great document!

[Colin-Albert]

Hi Joris

A good overview of issues related to date & time data are in these posts...

Why don’t my dates work?

Get the Dates Right

QlikView Date fields