I have the following issue. I have 2 fields:
ContactTime (General Date)
ReviewDate (Short Date)
The Review date needs to be automatically 14 days after the ContactTime. But when I set the default value of ReviewDate to =[ContactTime] + 14, the ReviewDate includes the time.
I'm trying to run a query on the ReviewDate, only to input a date, but because of the time that's included from the ContactTime field, the query doesn't work if I only put in a date.
Can someone please help me with this one.