How can use the ExecuteSQL for count the time_out?

1

Hi all,

I wonder if need to create ExecuteSQL for count the time_out in current month?

regards,

2

time_out is a field in your database?

e.g. in SQL:

ExecuteSQL ( "SELECT einDatum FROM Kontakte WHERE Month(CURRENT_TIMESTAMP) = Month(einDatum) AND Year(CURRENT_TIMESTAMP) = Year(einDatum)"; Char(9); Char(13) )

einDatum is a date field in the table Kontakte and we look for matching current month and year.

3

yes,the time_out is filed in my DB

4

You may not need to use SQL for this. You can perform a find for records of the current month, excluding records whose time_out field is empty. The found set is the number of records that have a time_out value for the searched month.

2 Likes
5

I've created the script below, and it's working perfectly. However, during testing, when I change it to the next month, it still gives me the value for the old month. It should return zero.

time_out
time_out938×542 59.8 KB

6

Sorry, I don't understand what you mean by the above.

7

Too many details are hidden in your script image. What is the layout where the find is performed? What is the table of this layout? What are the find details?

8

Thank you for following up about my issue, I solved after add criteria month current.