I may be imagining things, but I think the "strange" names for the globals are there for a specific reason - to make access faster. I will have to do some research in documentation or in Learning materials, but it came up during my preparation for InterSystems SQL Specialist certification. So, I would suggest leave the names as they are unless you're planning to go directly through globals to work with data.

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.