Hey guys,
I have a problem, which I really feel like I shouldn't be having. There is a field, [DateChanged], in my ODBC database. It is a date/time field. I don't need the time, and I search with date-only ranges, so I really need to remove the time part. Everything that I have searched has come up with 2 options.
1. Use DateValue([DateChanged])
2. Use format([DateChanged],"mm/dd/yyyy")
When using DateValue, if I search for #4/17/16# (with or without the #) I get the "expression is too complicated" error.
When using Format(), if I search for #4/17/16# (with or without the #) I get no results.
I am 100% stumped on what is going on, or what I am doing wrong. I appreciate any help.
If it makes a difference, the end goal is to be able to use this criteria in the final query: Between [Forms]![F_Switchboard]![DateFrom] And [Forms]![F_Switchboard]![DateTo]
Both of those date fields are stored as text, and work great everywhere else I use that statement.