help in queries please

[gokari]

Hi there,

I'm stuck with queries and I need a help please.



I need to calculate how many days from one date to another.

Everyone else can use the same formula except me.

Nights stay[Discharge Date]-[Date Admitted])



Thank you x

 

[pbaldy]

Not sure what you're saying, as it appears to be working. You can use the DateDiff() function.

 

[gokari]

Supposed to calculate 3 days but it calculates 91 days instead.

 

[Simon_MT]

What the two days being used?

Simon

 

[pbaldy]

Are they date/time fields? Looks like a date format problem, as the result looks correct with dates in US format.

 

[pbaldy]

Oh, and shouldn't the fields be reversed?

 

[gokari]

Thank you very much. I will try it now.