Invalid date in function DateValue. (180,113)

Invalid date in function DateValue. (180,113)

Apurva Tripathi
 

Apurva is a PeopleSoft consultant and a big advocate of everything PeopleSoft. He is also a technology enthusiast and loves learning and implementing newer and open source technologies. He spends his spare time updating this blog and likes to read books on self help and productivity.

Click Here to Leave a Comment Below 0 comments
2

Invalid date in function DateValue. (180,113)

Though this is a common problem – it shows up in a lot of different scenarios. The error is very similar and is “Invalid date in function DateValue. (180,113)”

For example, you can try to look at my benefits summary page on Employee Self Service.  The date defaults to say 2014/04/20, when you select the calculator, you may get an error message about the date format you entered is wrong.  Try a different format other than YYYY/MM/DD and you will realize that it does not work either. Ask your co-worker and he/she may very well be able to submit the date with the calendar tool.

The error “Invalid date in function DateValue. (180,113)” looks something like this:

Invalid date in function DateValue. (180,113)While it looks like one, but it may not be a data issue or an application issue.

One of the key solution, which you may not find documented is that you need to check your language settings in the browser used. Check Internet Settings and ensure that the language selected and the data input are in similar formats. For example, in this case the language preference in the browser was set to European English.

Apurva Tripathi
 

Apurva is a PeopleSoft consultant and a big advocate of everything PeopleSoft. He is also a technology enthusiast and loves learning and implementing newer and open source technologies. He spends his spare time updating this blog and likes to read books on self help and productivity.

Click Here to Leave a Comment Below 2 comments