One liner for subtracting 1 from date

view story

http://www.unix.com – I got a statement like below to subtract 1 from given date using teradata. I am looking for a one line unix command to perform the same. Code: select 'parse_this_record', (DATE '${FILE_DATE}' - 1) (FORMAT 'YYYY-MM-DD'); Input: 2012-02-21 Expected Output: 2012-02-20 PS: One liner because I am going to have this date value assigned to a parameter in Ab Initio, where I can't execute a script at parameter level. :wall: Thanks in adv !!! (HowTos)