Convert String DATA into Integer Or

[Shafique]

HI EVERYONE.
In this query, the days field returns the number of days from the LAST date to today, which is returned as a string. Then I move this query to another query where I want to be able to set the criteria of the number of days in the query. Please I want to know the BETWEEN criteria method of number of days in string field
1converting the STRING value into INTEGER
2between criteria in this field
ANY SOLUTION

 

[Joe4]

You only use Double-Quotes to denote TEXT entries. So remove them from all your formulas where you are wanting to return numbers.

So in your DAYS calculation, change

"0"

to

0

and in your BETWEEN criteria, use:

Between 0 And 90

 

[Shafique]

You only use Double-Quotes to denote TEXT entries. So remove them from all your formulas where you are wanting to return numbers.

So in your DAYS calculation, change

"0"

to

0

and in your BETWEEN criteria, use:

Between 0 And 90

"Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

.....I LOVE IT