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
try the below:
=time(date(DATETIME,'DD/MM/YYYY hh:mm:ss'),'hh:mm') as time
replace the DATETIME with your date filed
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
thanks nam, i will check with that
Retrieving data ...