Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.
Originally posted by: ThomasTI think this would do it?
if 'promoted field'.str() == "" then X = "1900-01-01".date("CCYY-MM-DD") else X = 'promoted field'
emit * override emit X as "promoted field"