Simple Formatting Issue...or is it???

[djkekos]

Here is my query field in a make table query:

Date of 3 month f/u due: IIf([Date of IC Review] Is Not Null,([INDEX_DATE]+83),"")

But I want the response of ([INDEX_DATE]+83) to be formatted as a date and not as text. The existing table field of INDEX_DATE is already in date/time format.

I've tried
Date of 3 month f/u due: IIf([Date of IC Review] Is Not Null,DateValue([INDEX_DATE]+83),"")
but to no avail.

Any ideas?

 

[Jeanette Cunningham]

If this query is feeding a form or report, you can set the format of the text box to short date ( or other date format) in the form/report.

If you want to format the result when you view the query, you can try using the format function as shown below, but it doesn't always work as you expect (in my experience).

Format([TheDateField],"mm/dd/yyyy").

There is also the option in the property dialog for that column of the query to choose the format - and that doesn't always work either (in my experience).

 

[tehNellie]

If Index_date is already a date field and you want 3 months

DateAdd("m",3,[Index_date])

If you want 83 days

DateAdd("d",83,[Index_date])

That should retain the data in date format.