Updating Date Field

[ebizleads]

I need to update a date field with a random date between a date range.

How do I do this? Thanks!

Ebiz

 

[PHV]

Int((MaxDate - MinDate + 1) * Rnd + MinDate)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ebizleads]

hmmm....I plugged this in and everthing went to 12:00am.

Int((8/1/2005-8/1/2004+1)*Rnd()+8/1/2004)

Thanks for your help!

Ebiz

 

[PHV]

Int((#2005-08-01#-#2004-08-01#+1)*Rnd()+#2004-08-01#)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886