MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

SPD Workflow - query record not between 2 dates

  Date: Sep 17    Category: MOSS    Views: 764

I have 2 lists I am using for an item checkout list. The first list is the
inventory items, and the second is the check out request list. When a person
checks out an item I need to ensure that the item is not already checked out for
the specified time. How can I do that in an SPD workflow? I've already got the
check out, and checkout expires automatically at the end of the specified time.
Just need to get the piece that ensures the item is available for that time!



3 Answers Found

Answer #1    Answered On: Sep 17    

Sorry, that should say "I have 2 lists I am using for an item checkout tool." I
realize this description might be clear as mud so feel free to ask questions for

Oh yeah, I am using MOSS 2007.

Answer #2    Answered On: Sep 17    

How are you identifying the item in the checkout list -- with a linked
field, or something else?

I know you can do things like "compare value", "create new list item", and
"update list item" based on criteria; where are you getting stuck?

Answer #3    Answered On: Sep 17    

In the checkout list, for any items that are checked out I have stored the ID of
the requested item. When someone checks out another item I don't care which one
it is as long as it does not conflict with any other reservations. Reservations
are stored with "From" and "To" fields. There are only 14 items in the list to
reserve, so not too cumbersome.

Didn't find what you were looking for? Find more on SPD Workflow - query record not between 2 dates Or get search suggestion and latest updates.