Maximum Date

[baylisj]

Can someone help please

To get the latest date in ORACLE I use

GREATEST('01-Oct-2004','10-Oct-2004') and the result would be '10-Oct-2004' as this is the latest date of the two.

Any idea what the function is in MICROSOFT ACCESS ?

I've tried MAX(date1,date2) but that doesn't work.

Any help grateful
Thank you

Jon

 

[Norie]

Are these two dates in the same field or different fields?

If they are the same field you could use totals and MAX to get the latest date.

If they are different fields you could use.

MaxDate:Iif([Date1]>[Date2], [Date1], [Date2])

 

[baylisj]

The dates are in different fields

I have done this

MaxDate : Iif(['10-Oct-2004'] > ['01-Oct-2004'], ['10-Oct-2004'], ['01-Oct-2004'])

and it doesn't seem to work.

Have I got it right at the beginning ??

Thanks for your reply

Jon

 

[Norie]

Are the name of your fields 10-Oct 2004 and 01-Oct 2004?

[Date1] and [Date2] in my post where meant to represent fields.

 

[baylisj]

Yes - so it needs to be

MaxDate : Iif('10-Oct-2004' > '01-Oct-2004', '10-Oct-2004', '01-Oct-2004')

Correct ?

Thank you

Jon

 

[Norie]

Sorry I still don't understand.

Are you actually comparing dates or two fields whose names are dates?

If the field names are the dates try this:

MaxDate : Iif([10-Oct-2004] > [01-Oct-2004], [10-Oct-2004], [01-Oct-2004])

 

[baylisj]

off home now but will post tomorrow

thanks for your help !

Jon