Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
swethasmilek
New 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

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

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

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

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
New Contributor III

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

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

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

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)