Is there any way to pass the DATE to the SORT ?
I need to select the records with the yesterday's date.
Let's say, there is a huge file which includes the data for the whole year. Each record has a date like '2011-02-28' in the pos 1 thru 10. So to select the records for just one day (and it is always for yesterday's date) the SYSIN will look similar to
Is any way to make '2011-03-20' be a result of the function, which let's say returns the todays date ?