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.
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)