Formatting Long Date

[kdbailey]

I have a field that tracks date and time of an occurrence. "m/d/yyyy h:mm:ss AM/PM"

Why can I not format this field to display "m/d/yyyy" for specific purpose or use datediff() or dateadd()?

[pbaldy]

If I had to guess, it's a text field rather than a date/time field. Try using CDate() on it.

[kdbailey]

The field is date, I can't even filter the field using a criteria of "<=dateadd('d',-30,now())"

I can query it for a specific date or <= a specific date, etc. But nothing involving dateadd.

[kdbailey]

Can't even filter <now().

[pbaldy]

Can you post the db here, or a representative sample?

[kdbailey]

I actually believe the database is corrupted somehow, it won't allow me to compact, it won't compile the basic formulas. I'm trying to find what caused it.