Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Start Time and End Time from Date

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

3 Replies
Employee
Employee

Re: Start Time and End Time from Date

Hi

try the below:

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

replace the DATETIME with your date filed

Employee
Employee

Re: Start Time and End Time from Date

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

Not applicable

Re: Start Time and End Time from Date

thanks nam, i will check with that

Community Browser