Adding Date

rafidwh · Post by **rafidwh** » Wed Oct 10, 2007 9:37 am

HI All,

I need to add 365 days to a date which is in yyyymmdd format.

I am using the function DateFromJulianDay(JulianDayFromDate(DSLink3.Date)+365)

But the output is *******.

The input datatype is Integer and output is also integer.

How to apply this logic.

Regards,
Rafidwh

rafidwh · Post by **rafidwh** » Wed Oct 10, 2007 9:40 am

Iam sorry input and output datatypes are char.

If Iam giving Integer then the job is giving a compilation error

DeepakCorning · Post by **DeepakCorning** » Wed Oct 10, 2007 10:07 am

Is this a delivered Routine or something custom??
You will need to find what arguments it takes as input and you may have to oconv the output in order to get the result.

ravibabu · Post by **ravibabu** » Wed Oct 10, 2007 12:11 pm

Hay ,

Use the Type conversion function like stringtodate and datetosting.

Bye

turash · Post by **turash** » Wed Oct 10, 2007 12:15 pm

If your source is RDBMS you can do that at database level using dateadd (sybase) or their variants in other RDBMS.

rafidwh wrote:HI All,

I need to add 365 days to a date which is in yyyymmdd format.

I am using the function DateFromJulianDay(JulianDayFromDate(DSLink3.Date)+365)

But the output is *******.

The input datatype is Integer and output is also integer.

How to apply this logic.

Regards,
Rafidwh

DSguru2B · Post by **DSguru2B** » Wed Oct 10, 2007 12:27 pm

Convert your char date into a valid date format by using StringToDate() and the 365 days using one of the parallel functions, cannot remember it off the top of my head. I know its there.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 10, 2007 4:10 pm

Try applying DateFromDaysSince() function to the date after converting from string.

DSXchange

Adding Date

Adding Date

Re: Adding Date