_days_between function not working in C10 RS with MS Access DB

[Sakthi]

Hi Friends,

I'm working on a POC and we are using MS Access as a db.
I have an attribute with Date Time datatype. Assume the attribute name is [Enrollment Date].

In C10 Report Studio, i'm using a data item [Aging]to find the difference between the current system date and [Enrollment Date].
I normally use _days_between function to find the difference.
Here i'm facing an error and i do not know what function needs to be used for MS Access or shouldn't i use current_date to find the system date.

Your help is much appreciated.

[bi4u2]

You can try using the cast function in the two query items that you are performing the _days_between against, to make sure that both items are considered dates. Example CAST([Invoice Date],date)