how to add days to the due date 1

[JeffMachine]

Macola version 7.6.400a

I would like to change some of my open AP item's due dates by adding 83 days to the trx_dt. In other words due_dt=trx_dt + 83 days.

This is simple when the date is stored as a date format, but how do you do it when the date is in yyyymmdd format?

P.S. I know how to create terms codes to do this, my users do not however and I need to correct some entries they already entered.

Thanks....

 

[dgillz]

Do you want this in a crystal report or do you actually want the database updated?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[JeffMachine]

I need to update the data.

 

[dgillz]

Pervasive or MS SQL?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[JeffMachine]

MS SQL

 

[crystalreporting]

In order to accurately add days to a YYYMMDD date, you'll need to convert it to a date e.g.

select trx_dt, dateadd(d,83,cast(cast(trx_dt as varchar) as datetime)) from APOPNFIL_SQL

Once you see that the resulting date is OK, you then need to convert it back to YYYMMDD format e.g.

select trx_dt, convert(varchar(8), (dateadd(d,83,cast(cast(trx_dt as varchar) as datetime))), 112) from APOPNFIL_SQL

When you're OK with that, it's simply a case of updating the due date with the results e.g.

update APOPNFIL_SQL set due_dt = convert(varchar(8), (dateadd(d,83,cast(cast(trx_dt as varchar) as datetime))), 112)

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.erpessentials.com

 

[JeffMachine]

Thanks crystalreporting, that worked perfectly.