I have a Ship date(June Data),I want to compare it with today(),
4 answers
the datediff formula will take the difference between the 2 date arguments and apply the appropriate sign datediff("day",today(),shipdate) will produce negative value for all ship dates prior to today
give it a try
Jim
