Software

Ask something
Discussion Locked

Calculate Due Date on a custom form

0 helpful
3 replies

by damianm 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have designed a Helpdesk request form in Outlook 2000. I have a drop down box with the different priority levels that users can assign their calls. What I want to do is calculate a due date for the request based on the sent time of the request andthe priority of the call. Anyone know how to do this?

Cheers,

Damian

3 replies

by j.wallace

Hello Damian, I've got an idea that might work.

In the Value for the Due Date, add to Request_Time with a big SWITCH structure. The pseudocode for this:

IF Pri=1, Due_Time = Request_Time + 1 hour
IF Pri=2, Due_time = Request_Time + 4 hours
and so on.

If you're coding this, you'll be using the DateAdd() function a lot.

Hoping this helps,
Rick

This discussion is closed to new replies.