• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Parameterized URL Problem

Does anyone know how dates are handled in a Parameterized URL?

I'm calling a custom fix inspect form using a parameterized URL that has a an ER select statement for the F95921 table for the FRROLE, TOROLE and EFFDATE primary key. I’m sending a date (EFFFDATE) as a parameter in Julian date format (I’m sending the value 116287) but I’m getting the following errors in the jas.log:-

10 Jun 2019 09:57:04,320 [SEVERE] NEALS - [BASE] com.jdedwards.database.base.JDBException: [INCORRECT_CONVERSION_TO_DBFORMAT] Formatting error on converting EFFDATE of Everest type 11 from OneWorld to database format. java.lang.IllegalArgumentException
10 Jun 2019 09:57:04,320 [SEVERE] NEALS - [BASE] com.jdedwards.database.base.JDBException: [INCORRECT_CONVERSION_TO_DBFORMAT] Formatting error on converting EFFDATE of Everest type 11 from OneWorld to database format. com.jdedwards.database.base.JDBException: [INCORRECT_CONVERSION_TO_DBFORMAT] Formatting error on converting EFFDATE of Everest type 11 from OneWorld to database format.

The parameterized URL works if I don't include the date, but the date is required to make the record unique.

Should dates be sent in Julian date format or another format or can't I use dates in a parameterized URL?

Thanks,

Neal
 
Neal,
The parameters should be entered the same way as if you were typing them directly into the target form. For example, your jdedate of 116287 should work if put in the parameter list as 10/13/2016, if you're using the USA date format of MM/DD/YYYY.

Good Luck!
 
Top