This project has moved and is read-only. For the latest updates, please go here.

Difference between two date columns

Nov 17, 2013 at 8:56 PM

I need to get a difference between two date columns in a query, but when I use 'DbFunctions.DiffDays' it gives me an error:

System.InvalidOperationException: Missing function mapping for Edm.DiffDays

It appears that this is not implemented yet, or am I missing something? .... is there any solution or workaround for this?

I would imagine a lot of people would be needing this.

Thanks in advance!
Nov 17, 2013 at 9:26 PM

Thank you for reporting this issue. This is your lucky day, I have already implemented this, but only published my changes recently. You can download the most recent version from the nightly build repository.
Marked as answer by tamasflamich on 1/25/2014 at 3:14 PM
Nov 18, 2013 at 7:07 PM
It works, Awesome!

Many thanks for prompt reply!