Stripping the time stamp

[xaic67]

I am pulling POS sales data into a query. I want to display this data by date ranges, however the timestamp is getting in the way. In my query I tried the following code, but it returns multiple years and does not recognize zeros? ie. I ask for date range 11/01/2006 - 11/15/2006 returns data from 11/10/2005 - 11/15/2006 code ex.

ConvDate: CDate(Month([dtmDate])&"/"&Day([dtmDate])&"/"&Year([dtmDate])

 

[Darrylles]

Hi x,

Have you tried Format?

e.g: ConvDate = Format([dtmDate], "Short Date")


ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[Darrylles]

X,

Sorry:

ConvDate: Format([dtmDate], "Short Date")

;-)



Never argue with an idiot, he'll bring you down to his level - then beat you with experience.