Question:
--------

Using the Progress keyword today in a formula results in an error.  

For example, with the following formula: 

substring(string(year(today)),3,2) + string(month(today)) + string(day(today)), 

we get the error: 

ERROR: File today does not exist in the database.  

Answer:
--------

Here is  an alternative way around this limitation.  Create the following EDI function 
keyword:

Funct. Keyword: todate
   Description: today
  Return Value: date 
Funct. Formula: today  

Use this function keyword in your formula.  For example,

Return value: character
Formula: substr(string(|TODATE|),7,2) + 
         substring(string(|TODATE|),1,2) +
         substring(string(|TODATE|),4,2)

In the interim, we are looking at allowing the keyword today to be used in a formula.