Hi,
Very new to MS-Access.
I'm trying to format the date and get the min of date but
its returning a wrong value.
select min(Format(emp.emp_date-DatePart("d",emp_date),'mm/dd/yyyy')) AS emp_date from emp ;
The values in the table are,
10/1/1992
11/1/1992
12/1/1992
1/1/1993
2/1/1993
I'm expecting a value after formatting is 09/30/1992. But its returning 01/31/1993. I think it gets the min of
the "day" part alone. Can you pls help out with the syntax ?
Thanks.
Very new to MS-Access.
I'm trying to format the date and get the min of date but
its returning a wrong value.
select min(Format(emp.emp_date-DatePart("d",emp_date),'mm/dd/yyyy')) AS emp_date from emp ;
The values in the table are,
10/1/1992
11/1/1992
12/1/1992
1/1/1993
2/1/1993
I'm expecting a value after formatting is 09/30/1992. But its returning 01/31/1993. I think it gets the min of
the "day" part alone. Can you pls help out with the syntax ?
Thanks.