Hello All,

I'm having a little problem in witting an SQL statement.
I'm sure there is a simple solution for it but its just not clicking with me!.

Anywayz,

I'm trying to write a statement that in the FROM clause, there is a formula, and i would like to assign conditions to this formula in the WHERE Clause
Ex:


I want the statement to convert the FLD_AS_STRING field (which is in string format) to Date format, and in the same time i want to only view fields that it's FLD_AS_STRING is greater than today's date (after it is converted to Date)?

How can i do that in this statement?


Thanks in advance,


Best Regards
Firas S Assaad