Setting a Date to Null in PeopleCode


To set a date to null in PeopleCode either use the SetDefault() function (deprecated) or the SetDefault field method

Using the function:

SetDefault(YOUR_RECORD.DT_FIELD);

Using the field method If you are in the current context:

YOUR_RECORD.DT_FIELD.SetDefault();

Using the field method if you are not in the current context using a field object:

Local Field &fldDateExample;
/* Code to set your &fldDateExample object */
&fldDateExample.SetDefault();

Not intuitive but it works.

There is also another way to set a date to null via PeopleCode! In some cases, using SetDefault() to blank out a field is not what we're after, as there may be a default for the field! The only other way (to my knowledge) is this:

RECNAME.DATE_FIELD.Value = "";

.Value is the KEY here. Not including .Value will throw Syntax errors in App Designer when you try to assign the date field to "" and save your program.


Revision #1
Created Thu, Aug 1, 2019 1:49 PM by PeopleSoft Wiki
Updated Thu, Aug 1, 2019 1:56 PM by PeopleSoft Wiki