Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
swethasmilek
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
Anil_Babu_Samineni

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
Anil_Babu_Samineni

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)
swethasmilek
Contributor III
Contributor III
Author

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

Anil_Babu_Samineni

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)