How do I select the date portion of a datetime field

[Guest]

I need to query a database from excel to return unique
records by date only from a date time field. I can select
day , Month or year what I need is mm/dd/yyy

Any suggestion
Thank

 

[Frank Kabel]

Hi Ray
try
=DATE(YEAR(A1),MONTH(A1),DAY(A1))
where A1 stores your datetime value
Frank

 

[Ray]

MS Query returns DATE is not a valid function

-----Original Message-----
Hi Ray
try
=DATE(YEAR(A1),MONTH(A1),DAY(A1))
where A1 stores your datetime value
Frank



.

 

[Frank Kabel]

Hi Ray
I would create a helper cell with this formula and reference this
helper cell instead of the original cell in MS Query

HTH
Frank