I am using Basic syntax to write the formula. I am basically going through some dates eg from 1st to 5th using a while loop. For each date i want to run a SQL count records query to get a total number of record for the period.
But i am not sure how to add an SQL query inside a formula field.
Would appreciate any help...