Skip to Content
avatar image
Former Member

How do I write a variable to get data from between two dates?

In a library I want to find the [total number of transactions] that happened within two dates (an academic year)

I have done this...

=[Total loan transactions] Where ([Transaction date] between (2010/09/01;2011/08/30))

but this gives me
"The expression or sub-expression at position 62 in the 'Between' function uses an invalid data type. (IES 10037)"

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 08, 2017 at 06:17 PM

    Need details on what product you are using and versions?

    Add comment
    10|10000 characters needed characters exceeded