sorting dates

  • Thread starter Thread starter Susie
  • Start date Start date
S

Susie

I'm trying to use the "first" criteria in an expression to
try to pull out the first event date in a grouping. The
problem is I have a date field from another application.
Some data includes both date and time and others just
include the date. The date field is set up as general
(date and time), and it is skipping any date that has a
time. I have tried to extract the date by using
the "DateValue", creating another field. If I try to use
that new field (with just the date value) it still comes
up with the first date without a time attached. Is there
any way to get around this? Thank you in advance for any
help!
 
Susie,

If you want to find the *earliest* date in your grouping and presuming you
have set Totals on in your query, simply insert Min in the Total: row of the
column containing your date field.
 
Back
Top