I made a small Access DB that has a Date field in it (DUEDATE). The DB is used for demonstration purposes to show current orders.
I need a function that would randomly update the orders due date in the table (orders). I would like to input a starting date and a range (30,60, Etc.) in a text box and have the function randomly create dates based on the start date and within the range input. If the DUEDATE column is empty or has another date should not matter.
I need a function that would randomly update the orders due date in the table (orders). I would like to input a starting date and a range (30,60, Etc.) in a text box and have the function randomly create dates based on the start date and within the range input. If the DUEDATE column is empty or has another date should not matter.
Do you want the code for the random date generator, or changing the DueDate Column, or both?
The random date generator could get messy, but I'll see what I can do.
Last edited by rstkw; Oct 26th, 2008 at 1:08 pm. Reason: Added last line.
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Unsolved 
