- Posts: 58
- Thank you received: 0
Add two dates
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
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.
- Peter.Jonson
-
- Offline
- Platinum Member
-
8 years 11 months ago #11770
by Peter.Jonson
Peter Jonson
ETL Developer
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;
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.
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.
- Peter.Jonson
-
- Offline
- Platinum Member
-
8 years 11 months ago #11772
by Peter.Jonson
Peter Jonson
ETL Developer
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.