Comments, tips & tricks on PeopleSoft products and technology.
Hi Sir faced same issue last week , tried this one local date &testdate ;Record.field.value = &testdate;by default &testdate is NUll :
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.
PeopleSoftNetHello 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
Hi AnandNo problem, I'll be happy to contribute to your PeopleSoft community. It seems a good place to share information among PeopleSofters.Cheers!
or you could simply do it with %DateNull
Hi ParagThe %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.
Parag is right.%DateNull is applicable for use in PeopleCode, AE, SQL
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.
Hi im eva peoplesoft consultant. I was just browsing blogs there I found your blog is interesting.. thanks for posting… keep on posting mypeoplesoft
Great job keep it up.
Thanks Javier :) I googled and your post helped me today.-Kyle from Belize :)
You're welcome Kyle! Nice to see you here :)
Almost seven years later, and this blog entry is still helping people... :-)
And whaddya know, now I have a followup question....How would you assign a datetime variable to null?
Hi DavidI think the following should work:Local datetime &dt;&dt = Date(0) + Time(0);Let me know if it doesn't.Thanks!
Post a Comment