May 03, 2011; 12:59
Andreas Carlsson
Problem with date format on shared database
This is a really strange problem.
One of our databases use the US date format instead of the Swedish. Ie, instead of "2011-05-03", it says "05/03/2011".
- Use system format is checked.
- Other databases on the same server works as they should.
- This is a copy from one of the working databases that works as it should.
- When scripting a search, there is a difference between "Insert Calculated Result" and "Set field". Both is using the same formula though (which is ""=E2=89=A4" & GetAsDate(Get ( CurrentTimeStamp ))"). Insert... sets the date to US format, Set field set it as System format. The upcoming dialogue though, presents the date in US format.
We have closed the database, opened it locally on a swedish client, and there it worked ok. When putting it on the server it doesn't work. This would have been understandable if ALL databases on the server behaved the same way, but the rest of them is working as they should.
Any ideas!?!
Clients: OS X and Windows. FM Pro Advanced 11.03
Server: Windows Server 2003 FM Server v11.02
Server language: English with swedish formats.
#############################################################
This message is sent to you because you are subscribed to
the mailing list <fmpro@lists.lassosoft.com>.
To unsubscribe, E-mail to: <fmpro-off@lists.lassosoft.com>
To switch to the DIGEST mode, E-mail to <fmpro-digest@lists.lassosoft.com>
To switch to the INDEX mode, E-mail to <fmpro-index@lists.lassosoft.com>
Send administrative queries to <fmpro-request@lists.lassosoft.com>