How do you convert a date to year only? 1

[djgolds]

I have a column in my table that is in date format example 01/25/2001. I'd like to convert this date to year only to do various queries. Even though I put my format as yyyy in the query, when it does the filtering, it returns numerous instances for the same year becase it still recognizes the date as 01/25/2001 rather than just 2001. Any help would be appreciated. Thanks!

 

[jimmythegeek]

Sometimes you need to create a seperate column, for example:

Yr: Format(YourDateField, "yyyy&quot

Now you can put criteria in this column like 1999, or 2000, and it should filter properly.

Let us know if I am not understanding you correctly.

Can you post the SQL part of you query? Jim Lunde
compugeeks@hotmail.com
Custom Application Development

 

[Quehay]

That's it! Turn off the "show" for the sort/parameter row.

Here's a question:

format(myDate,"yyyy&quot

DatePart("yyyy",myDate)

Which is more efficient?

 

[jimmythegeek]

Not Sure? Let's add one more

Format(myDate,"yyyy&quot

DatePart("yyyy",myDate)

Year(myDate)

I would think that they would all be close to the same as each function must evaluate a date. My guess is the last one may be a little more efficient because after evaluating the date, it does not have to format it, it simply returns the year. Just a hunch however. If anyone else knows, please jump in. Jim Lunde
compugeeks@hotmail.com
Custom Application Development