How to create a date field from another date field

[akpofureenughwu]

Hello everyone, I need assistance on a QV work.

I have a field on a QVD file and I am requested to create  another field date from the existing date field

in this relationship, New Date = 45 days + Posting date

Thanks

Please find the attached file.

[akpofureenughwu]

I got it. Check it out sir

[sunny_talwar]

This log file shows that execution was successful and there were no errors.

[akpofureenughwu]

Okay.. But the due date = posting date + 45 days is not working.....

[sunny_talwar]

That's what I want to see in the log file. Run your script which errors out and share the logfile.

[akpofureenughwu · Accepted solution]

Hello sunny, Thanks for your effort so far. I have successfully resolve the issue.

a friend of mine helped me. He introduced resident table technique.

See attached to  see script.