just from your posted image no.
can you load your original data without trying any modifications? does it load or do you get the error?
ie can you write this:
LOAD @1 FROM
(txt, codepage is 1252, no labels, delimiter is '|', msq);
If you can load that then try the UTC() function once you have got the date sucessfully into qlikview.
Or post a sample of your logfile
UTC() always returns real time (and gets updated every second) in UTC format, regardless the parameters you pass on it, so UTC(Now(2)), UTC(ABC) and UTC(2) and UTC() will return the same (at least in version 10 SR2). So it will always return the same date (now) regardless the value it gets from the field.
It would be great though if parameters will not be allowed or it throw an error when something is set within the brackets.
Hope that helps
This 1302472796254 looks like java miliseconds of Date class.
I don't think you can convert them with standart qlikview function
You can try something like this.
Calculations is wrong. I try showing logic
((((1302472796254/1000)/60)/60)/24)/365) +1970 , --Year
((((1302472796254/1000)/60)/60)/24/365)/12) -- Month
((((1302472796254/1000)/60)/60)/365) -- Date
I face this problem but this is was on database level (ms sql)
and i use dateadd function.
Load MakeDate(1970, 1, 1 ) + (YourDateColumn / (1000 * 60 * 60 *24)) as ResultingTimestamp
Basically you want to add the base date with the number of days since 1-1-1970. To do this you divide your timestamp per number of milliseconds in a day, then sum your base date.
This should work even for leap year adjustments.
If the result is not displayed correctly, check the tab Number in the Document Properties.
Edit: fixed the # in MakeDate (copy and paste pasted an invisible hyperlink...)
In addition to this provided bye chiesa80, which seems to me the closest approach to what you want to get, the following will return the complete timestamp in an interpretable format by QlikView:
LOAD *, TimeStamp(MakeDate(1970) + (OriginalTimeStampField / (1000 * 60 * 60 *24)), 'MM/DD/YYYY hh:mm:ss.fff') AS TimeStamp FROM Source
Now you can extract month, date, day, week and so from the field TimeStamp. Note that MakeDate doesn't have the "#" sign (probably a typo).
Hope that helps.