Hi,

I deployed a script a few weeks ago that automatically sets a date in a custom date field in a custom record.

Our European employees are now causing this script to fire and it looks like their local preferences for date format is causing a problem.

I am setting the date as mm/dd/yyyy.  Their preferences are dd/mm/yyyy.  When the record is saved from the script it throws the following error:

"You have entered an Invalid Field Value 9/14/2007 for the following field: custrecord_replacement_sent"

Can anyone suggest an easy way to determine and set the appropriate date format?  I sure hate the thought of having to do another lookup to a user's record to determine what their date preference is set to since that seems like a lot of overhead.