Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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$);
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
try this ..........
=date(Date + 30)
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
Date( [Invoice Date] + 30) as Duedate
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$);
Dear Gunjita,
Thanks for your help, it works
Chriss