# 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
Did you mean:
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

May be using these?

Diff:

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)
3 Replies

May be using these?

Diff:

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

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

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)