Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Date between different system settings


Recommended Posts

Hi all,

I have two files, one with no data (globalfile) showing data from the other (datafile).

In datafile I have a date field with format: 23/5/2005.

When showing this date field in globalfile it shows 23-05-2005 when leaving Date format as entered. I can change the way the date shows but when entering the field it reverts back to the unwanted format 23-05-2005.

When I create a test date field in globalfile I can use the format I want.


How can I make sure the date stays in the requiered format?

Link to comment
Share on other sites

Hello Mr Ease,

It sounds as though your files are set up with the 'Always use file's saved settings' option selected in the File Options>Text tab, and were created under different system defaults for date format.


If so, one way to solve this would be to change the setting to 'Always use current system settings'. Another would be to save a clone of each of the files (on the same system and with the date settings you want set at the system level) and re-import the data, then use the clones.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

Terms of Use