I need to collect the "MAX" date for data using a summary function in SQL designer. If I am not explaing this well, I am on the "field tab" of SQL Expert and for a date field I am specifying I want a MAX value as summary data. It give me the collection I want but the date values are now displaying as numbers instead of dates. Is there anyway I can get this to work where it returns a DATE value?
Thanks In Advance
Al Turi
Thanks In Advance
Al Turi