By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,466 Members | 1,141 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,466 IT Pros & Developers. It's quick & easy.

Min value of two date fields in same table

P: n/a
I need to find the earlier of two separate dates in the same table and
populate a field in the same table with the earlier date.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 28 May 2005 08:41:35 -0700, "swtrader" <da******@yahoo.com> wrote:

Write an update query. Use the DateDiff function to determine if
field1 is greater than field2, or vice versa. Use the IIf function to
output either field1 or field2.

Still problems? Show us what you have so far.

-Tom.

I need to find the earlier of two separate dates in the same table and
populate a field in the same table with the earlier date.


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.