Creating a Variable Question

[txwylde]

I am trying to create a variable which will give me the Starting On Hand Balance which is called <Opr All Qty>. I am also pulling up the Date posted. I am trying to get the Starting On Hand Balance based on the starting Date Posted.
When I tried:
=<OPR ALL QTY> where min(<Date Posted>)
I get a syntax error. I am assuming I need to add a select statement to my where clause? Or is there another way?
Thanks!

 

[Subhashab]

where have you used the formula in designer or BO

 

[txwylde]

Both <Date Posted> and <OPR ALL QTY> are variables in BO. I can not use the Min(<Date Posted>) because Min is a numeric function, not a date function. I had thought about creating a variable in BO where when you enter in the starting date, it will take that variable and pull the <OPR ALL QTY> for the date, but I run into the same problem with adding the condition for the Start Date. Any ideas?