Need a little help here.
Background: System is Win2K AS, time() inserted into a INT field.
Problem: Insert is working fine. I would like to group by Month, Day and Year. When I group by the entire date (includes time portion) everything works fine. When I try and format the date field to only select and/or group by Month, Day, Year it sets the date to Dec 31, 1969.
Any thoughts. Formatted_date does not work.
Though about selecting month(date) day(date) year(date) and grouping by those three vars.
Ned
Background: System is Win2K AS, time() inserted into a INT field.
Problem: Insert is working fine. I would like to group by Month, Day and Year. When I group by the entire date (includes time portion) everything works fine. When I try and format the date field to only select and/or group by Month, Day, Year it sets the date to Dec 31, 1969.
Any thoughts. Formatted_date does not work.
Though about selecting month(date) day(date) year(date) and grouping by those three vars.
Ned