topic Re: Date Between Difference in QlikView

Date Between Difference

Wed, 25 Feb 2015 05:01:05 GMT

Dear All,

I'm new in qlikview. Can you tell me how can i find out difference between two date.

Exp: FromDate: 01/02/2015

To Date : 07/02/2015 .. Result will be: 7

Regards,

Masba

Re: Date Between Difference

amit_saini — Wed, 25 Feb 2015 05:04:23 GMT

Masba,

Try this:

Interval(Today()-Date(Date#([Due Date for Released Design],'MMM, DD YYYY' )),'d') as NoOfDays,

where MMM, DD YYYY-> should be your date format.

Thanks

Re: Date Between Difference

amit_saini — Wed, 25 Feb 2015 05:05:33 GMT

Interval(Today()-Date(Date#(Your_date_Field,'MMM, DD YYYY' )),'d') as NoOfDays,

Thanks,
AS

Re: Date Between Difference

Anonymous — Wed, 25 Feb 2015 05:31:52 GMT

=Interval(date#(07022015,'DDMMYYYY')-date#(01022015,'DDMMYYYY'),'d')

Regards,

Laxmi

Re: Date Between Difference

Wed, 25 Feb 2015 05:34:56 GMT

Dear Amit,

Thanks for your reply.. I have two date fields.. One is "PO_DATE" and another is "Invoice_DATE". how can i add two fields in your formula..

Interval(Today()-Date(Date#(Your_date_Field,'MMM, DD YYYY' )),'d') as NoOfDays

Re: Date Between Difference

jyothish8807 — Wed, 25 Feb 2015 05:40:57 GMT

Hi Masba,

TRy like this:

=Interval(date#(PO_DATE,'DDMMYYYY')-date#(Invoice_DATE,'DDMMYYYY'),'d')

=Ceil(Interval(Date#(PO_DATE, 'MM/DD/YYYY') - Date#(Invoice_DATE, 'MM/DD/YYYY'), 'DD' ))

Regards

Re: Date Between Difference

Wed, 25 Feb 2015 05:43:00 GMT

Dear Laxmi Kuber,

Thanks a lot for your reply..

Re: Date Between Difference

Wed, 25 Feb 2015 05:43:34 GMT

Hi,

interval(PO_DATE-Invoice_DATE,'DD') difference will be in Days

interval(PO_DATE-Invoice_DATE,'DD:hh:mm') result will be in Days,hours and minuts

if you face any problem then convert both date into number format and then use interval .

like => num(PO_DATE) as PO_DATE

Regards

Vimlesh

Re: Date Between Difference

amit_saini — Wed, 25 Feb 2015 05:45:35 GMT

Than it should be like below:

Interval(Date(Date#(PO_DATE, 'MMM, DD YYYY'))-Date(Date#(Invoice_DATE,'MMM, DD YYYY' )),'d')

Thanks,

Re: Date Between Difference

PrashantSangle — Wed, 25 Feb 2015 05:50:31 GMT

Hi,

Use expression given by Amit

instead of Today() write to_date_fieldName

and Your_date_field write FromDate

Regards