How to Create Date Range values taking todays date as 12-jun-1999

[#1]

Hi Community Members,

I have my Ivoice Date(billing date) and want to take current date as 12-jun-1986.I have written the following code ,but I am not getting any result and also any error, please help me out in this issue

If(Num#(Today())-Num#(INVOICE)>=0 and (Num#(Today())-Num#(INVOICE)<=30),'0-30 Days',

If(Num#(Today())-Num#(INVOICE)>=31 and (Num#(Today())-Num#(INVOICE)<=60),'31-60 Days',

If(Num#(Today())-Num#(INVOICE)>=60 and (Num#(Today())-Num#(INVOICE)<=90),'61-90 Days',

If(Num#(Today())-Num#(INVOICE)>=90 and (Num#(Today())-Num#(INVOICE)<=120),'91-120 Days',

If(Num#(Today())-Num#(INVOICE)>=120 and (Num#(Today())-Num#(INVOICE)<=150),'121-150 Days',

If(Num#(Today())-Num#(INVOICE)>=151 ,'Over 150')))))) as ReceivablesAge

FROM

[..\QVd's\txBilling.qvd]

(qvd);

Regards,

Ramesh

[#2]

Sorry Ramasamy I am not getting the values.

[MayilVahanan · Accepted solution]

Hi

Please see the attached file.. I exported the invoice date from your application and used as inline table..As per your logic, receivable age look like the following..

[#4]

Yes Ramasamy, I got it,

Kindly  explain why should we take Load * inline(invoice date) date values

regards,

rams

[MayilVahanan]

HI

For my convenience, i used it.. i can't able to reload the file know .. So for testing purpose i used it.

[Anonymous]

Hello, can you tell me how solve this problem. I have the same problem

I can`t get to Receivable