topic Convert Time to Number in QlikView https://community.qlik.com/t5/QlikView/Convert-Time-to-Number/m-p/450306#M168003 <HTML><HEAD></HEAD><BODY><P>I have data that is time-stamped with the date and time as a number.&nbsp; I can convert that to date and time without any problem.&nbsp; It's also in GMT time and I can convert the date and time to local time.&nbsp; What I'm having trouble with is I want to ad a slider object so the user can select a time range.&nbsp; I can do this but my time range is represented in GMT.&nbsp; I'm in the Eastern time zone (GMT - 5) so my slider goes from 7:00 PM to 6:59 AM and I would like it to go from 12:00 AM - 11:59 PM local time, of course.&nbsp; I've tried sorting my slider different ways but I cannot seem to get it to work.&nbsp; This is my slider field</P><P></P><P>=Time(ConvertToLocalTime(Frac([Date Time(RAW)])))</P><P></P><P>where [Date Time (RAW)] is the numeric value of the date and time of the data.</P><P></P><P>I've tried sorting on this same expression without any luck.&nbsp; Any ideas on how to do this?</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 23 Jan 2013 21:34:36 GMT 2013-01-23T21:34:36Z Convert Time to Number https://community.qlik.com/t5/QlikView/Convert-Time-to-Number/m-p/450306#M168003 <HTML><HEAD></HEAD><BODY><P>I have data that is time-stamped with the date and time as a number.&nbsp; I can convert that to date and time without any problem.&nbsp; It's also in GMT time and I can convert the date and time to local time.&nbsp; What I'm having trouble with is I want to ad a slider object so the user can select a time range.&nbsp; I can do this but my time range is represented in GMT.&nbsp; I'm in the Eastern time zone (GMT - 5) so my slider goes from 7:00 PM to 6:59 AM and I would like it to go from 12:00 AM - 11:59 PM local time, of course.&nbsp; I've tried sorting my slider different ways but I cannot seem to get it to work.&nbsp; This is my slider field</P><P></P><P>=Time(ConvertToLocalTime(Frac([Date Time(RAW)])))</P><P></P><P>where [Date Time (RAW)] is the numeric value of the date and time of the data.</P><P></P><P>I've tried sorting on this same expression without any luck.&nbsp; Any ideas on how to do this?</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 23 Jan 2013 21:34:36 GMT https://community.qlik.com/t5/QlikView/Convert-Time-to-Number/m-p/450306#M168003 2013-01-23T21:34:36Z Re: Convert Time to Number https://community.qlik.com/t5/QlikView/Convert-Time-to-Number/m-p/450307#M168004 <HTML><HEAD></HEAD><BODY><P>Can you attach your sample file?</P></BODY></HTML> Mon, 01 Apr 2013 15:31:25 GMT https://community.qlik.com/t5/QlikView/Convert-Time-to-Number/m-p/450307#M168004 Qvmaster2019 2013-04-01T15:31:25Z