user29188

Passing Date with PSOS

Discussion created by user29188 on Sep 6, 2017
Latest reply on Sep 7, 2017 by beverly

I was beginning to think I was going mad as a script I wanted to run on the server was running perfectly well locally in testing but wouldn't run when using PSOS (I was aware of the need to get the server environment the same as mine etc.) After about 2 days of debugging and generally scratching my head, I found that the date on the server was mm/dd/yyyy whereas the date on my PC was dd/mm/yyyy. As both are based in the UK, how was I supposed to know that the format would change?

 

Ultimate solution was to send the date as 3 values in the parameter list and then reconstructing the date with the Date function in the script but what a pain.

 

Anybody got any better solutions, preferably getting the server to work with the system format?

Outcomes