topic Start Time and End Time from Date in QlikView

Start Time and End Time from Date

Wed, 10 Oct 2012 10:27:58 GMT

Hi,

I have two date fields like dte1 and dte2. dte1 contains the starting time and its a datetime field in Sql and dte2 too. How can i split the time from that date in QlikView, also how can i add certain time to the retrieved time from dte1.

Thanks in advance

Re: Start Time and End Time from Date

nam — Wed, 10 Oct 2012 10:39:22 GMT

try the below:

=time(date(DATETIME,'DD/MM/YYYY hh:mm:ss'),'hh:mm') as time

replace the DATETIME with your date filed

Re: Start Time and End Time from Date

nam — Wed, 10 Oct 2012 10:46:10 GMT

If you want the time field use my solution if you just want the date without the time then rohit's solution will work perfectly

Re: Start Time and End Time from Date

Wed, 10 Oct 2012 10:50:19 GMT

thanks nam, i will check with that