How to get earliest date among 3 dates

How to get earliest date among three different date values.Also consider null values in it.



Example

date1=01/07/00

date2=Null

date3=01/08/00



how to get earliest among the above dates


Comments

  • : How to get earliest date among three different date values.Also consider null values in it.

    :

    : Example

    : date1=01/07/00

    : date2=Null

    : date3=01/08/00

    :

    : how to get earliest among the above dates

    :



    Use the new "least" function for 8i.


  • : Use the new "least" function for 8i.

    :



    if you don't have 8i, then you have to change the date format to a year||month||day number and do a min(). There are a lot more ways to skin this cat.




Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories