Start Time and End Time from Date

[#1]

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

[nam]

Hi

try the below:

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

replace the DATETIME with your date filed

[nam]

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

[#4]

thanks nam, i will check with that