Add a number of days to a Date in PX job

[Hongqing]

In a PX job, I am trying to add a number (days) to a date and come up with a new date. For example, I want to add 185 day to date 2003-05-24 and come up with a new date. Can any one help?

Thanks in advance.

[lstsaur]

[quote="Hongqing"]In a PX job, I am trying to add a number (days) to a date and come up with a new date. For example, I want to add 185 day to date 2003-05-24 and come up with a new date. Can any one help? :idea:

Thanks in advance.[/quote]

You first convert 2003-05-24 to a Julian day; then add 185 day to the Julian day; last convert the result back to the date format that you want.

[chulett]

Details, man, details!

[T42]

Code: Select all

DateFromJulianDay(JulianDayFromDate(input.field) + 185))

nuff details?