Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

[img https://res.cloudinary.com/eng

[img https://res.cloudinary.com/eng

[img https://res.cloudinary.com/eng


I'm looking for help on a formula that will take the due date and minus the days giving a new op date, but working backwards so that the operation Desp = the due date (03/03/2021) and the operations prior to Desp would calculate using the new op date minus days e.g

Op 5 Desp due date (03/03/2021) - 1 day = op date (02/03/2021) op 4 Rework due date (02/03/2021) - 1 day = op date 0(01/03/2021) etc. Any assistance would be a great help.

RE: [img https://res.cloudinary.com/eng

You should be able to just do a regular math expression (in a formula), i.e, {due_date} - {Days}, but you also could use the date add function. Something like this, dateadd('d', -{days}, {due_date}

RE: [img https://res.cloudinary.com/eng

Thanks Kray4660, i have that already what i was wanting to do is start at the last operation which is always Despatch then minus the days on that operation which would return a new date of 2/3/21 then take that date (2/3/21) and minus the days from the previous operation (on this example Rework)minus days returning a new op date of 1/3/21 and so on working backwards on the operations

RE: [img https://res.cloudinary.com/eng

Working with the dateadd and datediff functions to manipulate dates works really good for me. Lots of luck.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close