Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

How to Formatting DATE Field (YYYY-MM-DD :hh:mm:SS) into dates interval

Problem facing while  trying the convert of  timestamp(YYYY-MM-DD :hh:mm:SS) into date format   and get the duration of two dates .

1 Solution

Accepted Solutions
Highlighted

May be using these?

Diff:

Load

Date(Date#(UPLD_TS,'YYYY-MM-DD-hh.mm.ss.ffffff'),'YYYY-MM') as Date,

Date(Date#(PROCESS_TS,'YYYY-MM-DD-hh.mm.ss.ffffff'),'YYYY-MM') as Date1,

Date(Date#(UPLD_TS,'YYYY-MM-DD-hh.mm.ss.ffffff'),'YYYY-MM-DD:hh:mm:SS') as Time

resident Time ;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

3 Replies
Highlighted

May be using these?

Diff:

Load

Date(Date#(UPLD_TS,'YYYY-MM-DD-hh.mm.ss.ffffff'),'YYYY-MM') as Date,

Date(Date#(PROCESS_TS,'YYYY-MM-DD-hh.mm.ss.ffffff'),'YYYY-MM') as Date1,

Date(Date#(UPLD_TS,'YYYY-MM-DD-hh.mm.ss.ffffff'),'YYYY-MM-DD:hh:mm:SS') as Time

resident Time ;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Highlighted
Contributor III
Contributor III

Anil thanks,how can to get the difference of two dates i.e., duration b/w two time frames

Highlighted

May be this?

Date(Interval(Date-Date1),'YYYY-MM-DD:hh:mm:ss') as Date2;

Explanation: Here, Interval works as Number after that we need to control as out requirement using Date function

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)