topic Time Stamp Analysis in QlikView https://community.qlik.com/t5/QlikView/Time-Stamp-Analysis/m-p/366466#M136309 <HTML><HEAD></HEAD><BODY><P>Help Please!</P></BODY></HTML> Fri, 23 Mar 2012 16:50:59 GMT 2012-03-23T16:50:59Z Time Stamp Analysis https://community.qlik.com/t5/QlikView/Time-Stamp-Analysis/m-p/366465#M136308 <HTML><HEAD></HEAD><BODY><P>Hi I have the follwoing time stamp loading from a txt file.</P><P></P><P>timestamp(dateTimeOrigination/86400+makedate(1970,1,1)+interval#(-5,'h')) as TimeStamp</P><P></P><P>the output of it is as follow: M/D/YYYY H:MM:SS PM or AM</P><P></P><P>how can I separte the Month by itself&nbsp; on a month field and the time on a different field as well?</P><P>Thxs,</P><P>Badr</P></BODY></HTML> Fri, 23 Mar 2012 14:35:16 GMT https://community.qlik.com/t5/QlikView/Time-Stamp-Analysis/m-p/366465#M136308 2012-03-23T14:35:16Z Time Stamp Analysis https://community.qlik.com/t5/QlikView/Time-Stamp-Analysis/m-p/366466#M136309 <HTML><HEAD></HEAD><BODY><P>Help Please!</P></BODY></HTML> Fri, 23 Mar 2012 16:50:59 GMT https://community.qlik.com/t5/QlikView/Time-Stamp-Analysis/m-p/366466#M136309 2012-03-23T16:50:59Z Time Stamp Analysis https://community.qlik.com/t5/QlikView/Time-Stamp-Analysis/m-p/366467#M136310 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>Month(timestamp(dateTimeOrigination/86400+makedate(1970,1,1)+interval#(-5,'h'))) as Month,</P><P>Time(Frac(timestamp(dateTimeOrigination/86400+makedate(1970,1,1)+interval#(-5,'h')))) as Time</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Fri, 23 Mar 2012 18:56:50 GMT https://community.qlik.com/t5/QlikView/Time-Stamp-Analysis/m-p/366467#M136310 Jason_Michaelides 2012-03-23T18:56:50Z Time Stamp Analysis https://community.qlik.com/t5/QlikView/Time-Stamp-Analysis/m-p/366468#M136311 <HTML><HEAD></HEAD><BODY><P>That didn't work.</P><P>Thxs,</P></BODY></HTML> Fri, 23 Mar 2012 19:31:38 GMT https://community.qlik.com/t5/QlikView/Time-Stamp-Analysis/m-p/366468#M136311 2012-03-23T19:31:38Z Time Stamp Analysis https://community.qlik.com/t5/QlikView/Time-Stamp-Analysis/m-p/366469#M136312 <HTML><HEAD></HEAD><BODY><P>Please give some more detail - what didn't work, exactly?&nbsp; Or, better still, post your app.</P></BODY></HTML> Fri, 23 Mar 2012 19:52:30 GMT https://community.qlik.com/t5/QlikView/Time-Stamp-Analysis/m-p/366469#M136312 Jason_Michaelides 2012-03-23T19:52:30Z