Need help to add numeric value with date field

[#1]

Good Morning All,

When I try to add 30 days with a date filed the output is wrong, I tried like this =Invoice date +30 it shows incorrect value.

How to do this..Can you help me..

Chriss

[kaushiknsolanki]

Hi,

    First thing make sure that the field contains valid date.

    Second if you want to change the month (30/31 days) you can use the addmonth() function to achieve it.

    For more on addmonth() look for Qlikview Help.

    If not then please send us the sample qvw file.

Regards,

Kaushik Solanki

[#3]

try this ..........

=date(Date + 30)

[#4]

Hello Kaushik,

Thanks for your reply, In the script itself I would like to add 30 days with the Invoice date for calculation.

is it possible..

LOAD [Invoice Number],

     [Invoice Date],

     [Invoice Date] as duedate +30

FROM

(biff, embedded labels, table is Sheet1$);

Regards

Chriss

[#5]

Date( [Invoice Date] + 30) as Duedate

[#6 · Accepted solution]

Dear Chriss,

if u want to add 30 days in invoice date to make it due date u should write the script like this

Load [Invoice Number],

[Invoice Date],

date([Invoice Date]+30) as DueDate

FROM

(biff, embedded labels, table is Sheet1$);

[#7]

Dear Gunjita,

Thanks for your help, it works

Chriss