Datetime field format error – PeopleSoft Tutorial

Datetime field format error

This is a quick short post for resolution of the datestamp error while running a PS Query. Datestamp errors are quite common when running a PS Query.

When you run a PS Query and are prompted to enter the datetime value – many a times you will end up entering a wrong format and you will receive an error, which says “Datetime field format error. Please reenter using the proper format. This field allows for entry of a datetime value. Use the formats set in the international section of your Windows Control Panel.”

This field allows for entry of a datetime value

All you need to do is look at the clock in the right bottom of your computer and enter it accordingly. For example, my right bottom clock shows 2:11 PM 1/3/2015 – I will enter it when prompted as 1/3/2015 2:11 PM and the date conversion will happen automatically for the query.

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.


Download Complete List of PeopleTools Tables List. Never Again Google It !