topic Re: calculate current date in QlikView

calculate current date

Nagaraju_KCS — Fri, 06 Dec 2013 10:49:15 GMT

Hi Community,

i have a one product table

table:

start_date end_date

12/03/2013 12/03/2015

09/11/2013 12/02/2019

25/09/2013 12/08/2020

05/06/2013 12/12/2015

how to calculate current date in between st_date and end_date..

based on start and end dates..

using where condition (scripting level)

Thanks in Advance......

Re: calculate current date

swuehl — Fri, 06 Dec 2013 11:13:24 GMT

Maybe like

Set DateFormat = 'DD/MM/YYYY';

LOAD * INLINE [

start_date, end_date

12/03/2013, 12/03/2015

09/11/2013, 12/02/2019

25/09/2013, 12/08/2020

05/06/2013, 12/12/2015

05/06/2013, 11/09/2013

31/12/2013, 01/01/2020

]

where start_date <= today() and end_date >= today() ;

Re: calculate current date

Nagaraju_KCS — Fri, 06 Dec 2013 11:20:50 GMT

Thanks for reply,

one more how to calculate how many years and months validity

Re: calculate current date

jagan — Fri, 06 Dec 2013 11:24:56 GMT

HI,

Try like this

=Year(end_date) - Year(start_date)

Regards,

Jagan.

Re: calculate current date

Fri, 06 Dec 2013 11:26:06 GMT

Hi,

Can you give some more details, because current date will be today () but you are asking between St_Date and End_Date.

What if we do not have current date between those ranges?

What are you planing to get out of that?

Regards,
NR

Re: calculate current date

Nagaraju_KCS — Fri, 06 Dec 2013 11:36:16 GMT

Hi jagan,

i want months alsoo..

Re: calculate current date

jagan — Fri, 06 Dec 2013 11:45:22 GMT

Hi,

Try like this

=Floor((Year(end_date) *12 - Year(start_date) * 12) /12) & ' Years ' & Mod(((Year(end_date) *12 - Year(start_date) * 12) ), 12) & ' Months'

Regards,

Jagan.