AnsweredAssumed Answered

Date conversion problem

Question asked by CarlSchwarz on Oct 1, 2013
Latest reply on Oct 1, 2013 by CarlSchwarz

For a find I use "Insert calculated result" to insert a date range if required into a date field for a search.

This has worked fine for me in the past in FM11.

However now I'm using FM12 and perhaps this problem is FM12 related or perhaps it's this server setup.

 

The problem is I use a global date field to pick a date, I then script

Insert Calculated Result [ getastext(search date) ]

The getastext script step is returning the American date format and it's making this search fail because the file is set to use the Australian date format! A dialogue box appears asking for the correct date format to be entered.

 

Has anyone come across this before? Is there a server setting I need to change?

Outcomes