Convert Short text column to date ms access

[SameerSarswat]

Select * from Table where CDate(CStr(Nz(AnnouncementDate,0))) >=CDate(10-10-2014) and CDate(CStr(Nz(AnnouncementDate,0))) <= CDate(01-10-2014);




here AnnouncementDate Column is Short Text

it gives me a type mismatch error..

please tell me how to solve this.

[June7]

Try using # delimiters:

Select * from Table where CDate(Nz(AnnouncementDate,0)) BETWEEN #10/10/2014# AND #01/10/2014#);

The date range doesn't make sense. Aren't the dates backwards? It does seem to make a difference in my testing.

Also, CDate(CStr(Nz(AnnouncementDate,0))) will return 12:00:00 AM if the field is null and no records return - is that what you want?

[SameerSarswat]

Hello Moderater

its not solving my prob. its sending me same error of type mismatch in criteria exp.

i have putted like this

Select * from table
where CDate(Nz(AnnouncementDate,0)) BETWEEN #10-10-2014# AND #01-10-2014#

[June7]

Works for me.

If you want to provide db for analysis, follow instructions at bottom of my post.