Tuesday, February 23, 2010

Setting Date Variables to Null in PeopleCode

If you try to assign a date variable a null value you will get an error saying that the left and right sides of the assignment are not compatible.

For instance, the following PeopleCode would error out:

Local date &myDate;

&myDate = null;

To perform this kind of assignment, you may use the Date function in the following way:


Local date &myDate;

&myDate = Date(0);
a la/s

16 comments:

  1. Neeraj KholiyaMarch 26, 2010 at 5:03 AM

    Hi Sir

    faced same issue last week , tried this one

    local date &testdate ;

    Record.field.value = &testdate;

    by default &testdate is NUll :

    ReplyDelete
  2. Javier DelgadoMarch 29, 2010 at 8:54 AM

    That's right Neeraj, although I prefer to specifically assign values to variables rather than use their default vale. Anyway, that's more a question of programming style of each developer.

    Thanks for your feedback.

    ReplyDelete
  3. AnandApril 6, 2010 at 2:33 PM

    PeopleSoftNet
    Hello Javier,
    Thanks for such a nice blog.
    We would like to have your comments on below site being developed for peoplesoft developers to help PeopleSoft Community.
    we expect response from you.
    Thanks in advance for your time and comments.
    PeopleSoftNet

    ReplyDelete
  4. Javier DelgadoApril 7, 2010 at 12:40 PM

    Hi Anand

    No problem, I'll be happy to contribute to your PeopleSoft community. It seems a good place to share information among PeopleSofters.

    Cheers!

    ReplyDelete
  5. UnknownApril 9, 2010 at 10:01 PM

    or you could simply do it with %DateNull

    ReplyDelete
  6. Javier DelgadoApril 12, 2010 at 3:21 PM

    Hi Parag

    The %DateNull seems to be Meta-SQL and as far as I tried would not work in PeopleCode (I've tried with PeopleTools 8.50). Also checked the PeopleBooks documentation and it does not appear as a system variable but only as Meta-SQL.

    Which PeopleTools version were you using to make the %DateNull value work?

    Thanks for your contribution.

    ReplyDelete
  7. UnknownMay 18, 2011 at 9:05 AM

    This comment has been removed by the author.

    ReplyDelete
  8. UnknownMay 18, 2011 at 9:05 AM

    Parag is right.

    %DateNull is applicable for use in PeopleCode, AE, SQL

    ReplyDelete
  9. Rakesh @ PsoftsearchSeptember 27, 2011 at 6:41 PM

    Last week a delivered code was throwing an error like this. We found that the culprit was a month() to which a null value was being passed.

    ReplyDelete
  10. Javier DelgadoAugust 20, 2013 at 8:27 AM

    Thanks Eva!

    ReplyDelete
  11. Peoplesoft forumDecember 23, 2013 at 10:23 AM

    Great job keep it up.

    ReplyDelete
  12. UnknownMarch 11, 2016 at 12:38 AM

    Thanks Javier :)
    I googled and your post helped me today.

    -Kyle from Belize :)

    ReplyDelete
  13. Javier DelgadoMarch 11, 2016 at 10:26 AM

    You're welcome Kyle! Nice to see you here :)

    ReplyDelete
  14. DavidJanuary 19, 2017 at 6:53 PM

    Almost seven years later, and this blog entry is still helping people... :-)

    ReplyDelete
  15. DavidJanuary 19, 2017 at 8:41 PM

    And whaddya know, now I have a followup question....

    How would you assign a datetime variable to null?

    ReplyDelete
  16. UnknownJanuary 20, 2017 at 12:22 PM

    Hi David

    I think the following should work:

    Local datetime &dt;

    &dt = Date(0) + Time(0);

    Let me know if it doesn't.

    Thanks!

    ReplyDelete