The original value that is in the table that I want to recode will always be 01/01/1900. I want to recode that to today's date. This only returns a blank, and not today's date. Any idea what I need to change?
Thanks!
Transfers << Begin Data Update;
Transfers << Recode Column(
Transfers:OrderDate,
{Map Value( _rcOrig, {-126144000, short date(today())}, Unmatched( _rcNow ) )},
Update Properties( 1 ),
Target Column( :OrderDate )
);
Transfers << End Data Update;