Could you solve this with a simple formula field using Days from Today?
If you want to continue with rankings, you will also need to consider the distance of self (current record) from all other Training Start Dates. Here is one way to solve.
Example: fid 6 = Start Date; also substitute in your values for Traditional and Available in place of Full
var text query = "{6.AF.'" & Today() & "'}AND{6.BF.'" & [Start Date] & "'}AND{'" & [Type] & "'.EX.'Full'}";
If(
[Type] = "Full" and [Start Date] > Today(), Size(GetRecords($query) ) + 1,
null
)
Also, it looks like you have a terminating character with your first formula - before the first "AND": &"';}AND
