All
Accepted answers
Iryna Mykhailova · Mar 28, 2025 go to post

Points made by Enrico are 100% valid and you may need to consider them.

In your case, because your column is not named, you can use GetData(n) to get the count:

set sql = "SELECT COUNT(*) FROM "_tableName_" WHERE "_fieldName_">='"_fromDate_"' AND "_fieldName_"<='"_currentDate_"'"
set resultset = ##class(%ResultSet).%New("%DynamicQuery:SQL")
set SC = resultset.Prepare(sql)
set SC = resultset.Execute(sql)
write resultset.GetData(1)

Obviously don't forget to check the statuses.

Iryna Mykhailova · Mar 24, 2025 go to post

As far as I know training does not include certification but it will obviousely increase your chances to answer more questions correctly and thus receive certification. In any case, I would definitely recommend doing the offline course - it's money well invested.

Iryna Mykhailova · Feb 20, 2025 go to post

Well deserved, congratulations! I always read your FAQ articles, useful stuff!

Good luck with obtaining the black belt! Coming from a blue belt in Kung Fu 😁

Iryna Mykhailova · Jan 22, 2025 go to post

I'm very honored to be among the best authors of the Developer Community in different nominations! Congratulations to everyone!

Iryna Mykhailova · Oct 11, 2024 go to post

Thank you for this suggestion.

PS. Being fluent in Russian won't help in this case, because the interface is in Ukrainian 😁

Iryna Mykhailova · Sep 3, 2024 go to post

Congratulations to the winner! This was an interesting experience 😁 I hope we will get more sweepstakes like this!

Iryna Mykhailova · Jul 23, 2024 go to post

Thanks a lot for the quick feedback! Now I will know what to do if something goes awry 😉