DateDiif Query returns blank data?

[MarkF2004]

Hello there

I am trying to calculate the number of days between two dates in a very basic access database and I think I followed the instructions properly but clearly have omitted a key element somewhere.

This is the code I have entered: Days Supported: DateDiff("d",[Date_Closed],[Date_Referral_Received])

NB I have tried swapping the two columns in the square brackets around but the same outcome is reached. I.e. the column for 'Days Supported' is completely blank.

I tried posting a screenshot of the design screen but I am not sure I have permission to do that as yet.

I shall continue checking prior suggestions but if anyone can see what I have done incorrectly and can repoint me, that would be great. Please ask if any further info is needed.

Kind regards



Mark

[MarkF2004]

Aha... I found the way... this may help.

[MarkF2004]

And this is what the outcome looks like...

[orange]

More info on DateDiff

Are you sure there are valid dates in [Date_Closed] [Date_Referral_Received]

OOps: I think we were posting at the same time.

[Bulzie]

Switch the dates:

Days Supported: DateDiff("d", [Date_Referral_Received], [Date_Closed])

[MarkF2004]

Hi again and thank you for the responses,

When you say "switch the dates around", do you mean just in the formula or actually swap the columns? I have tried the formula in both ways but both times it is blank. I wondered if the date format in the columns was inputted incorrectly? (I am inputting in British format, would the US format make a difference?)

I will be persevering with this over the weekend so I am grateful for your assistance.

[Bulzie]

Think it is that Date Closed format. Try this:

Days Supported: DateDiff("d",[Date_Referral_Received],DatePart("m",[Date_Closed]) & "/" & DatePart("d",[Date_Closed]) & "/" & DatePart("yyyy",[Date_Closed]))

[Micron]

I'm seeing Date_Referral_Received in the post, and Date Referral Received in the image?? Same for Date_Closed.
The date order will only affect the sign (+ or-), not produce no results.
I'm also seeing special characters in field names (?) - a big no-no! Not to mentions spaces as well...