Add two dates

More
8 years 11 months ago #11769 by amathur
Add two dates was created by amathur
Hi,

I have date in one field and number of months in the other. I want to populate target field by changing the date by adding the number of months to the date.

e.g. suppose date is coming as 10-10-2010 and number of months as 3, then output should be 10-01-2010

Thanks and regards,

Ayush

Please Log in or Create an account to join the conversation.

More
8 years 11 months ago #11770 by Peter.Jonson
Replied by Peter.Jonson on topic Add two dates
You can use calculation for that, this one worked for me

begin
Result:= IncDateS([F001],'YYYY-MM-DD','MONTH',[F002]);
end;

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
8 years 11 months ago #11771 by amathur
Replied by amathur on topic Add two dates
Thanks,Is IncDateS a function??

Please Log in or Create an account to join the conversation.

More
8 years 11 months ago #11772 by Peter.Jonson
Replied by Peter.Jonson on topic Add two dates
it is a function and you will find it in the documentation

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.