Skip to Content
0

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

Sep 08, 2017 at 06:17 PM

19

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Don Williams
Sep 08, 2017 at 06:17 PM
0

Need details on what product you are using and versions?

Share
10 |10000 characters needed characters left characters exceeded