I do not think there is a way to do this, but you can do a couple of things to get the data you want.
If its just an appearance thing, you can change the look of the date entered to your desired format using the inspector tab / Data. At the bottom there's a data formatting section. This will allow you to make the field data LOOK how you want. The underlying data doesn't change, just the rendering on the layout. In this section, click on the calendar icon and choose from one of the presets or create your own using the fields in that area.
A date field needs the mm/dd/yyyy format, so you can't strip out the '20' but you can create another TEXT field that is a calculation of the date field.
_Day = Day (YourTable::Date);
_Month = Month (YourTable::Date);
_Year = Year(YourTable::Date);
_Day &"/" & _Month &"/"& Right(_Year ; 2 )
This field is only a text field and can't be used to do any sorting by date. You probably could find a date using this field.
The date format (when you enter the date using "Ctrl -") will depend on how you set up Data Entry in the File Options (File > File options > Text > Data entry).
By default, "Use system settings" is selected, so if it the case and your systems settings are MM/DD/YYY, that is the format you will get when using the shortcut keys. If you keep Data entry setting to "Use system settings" you will have to alter the date format at the system level (ie Windows 7) to make the change.
If your Data entry setting is "Use file's saved setting", you will use the format saved onto the file. Whatever that format is.
To my best knownledge, a file will retain the system format setting at the time of its creation.
Hope that helps.
the date is always in the dd/mm/yyyy (european) format - means year is 4 digits. When You enter the date - or if You click into the date field - it appears as 4 digit year.
but: You can format a date that it shows the year as a 2 digit value - via the inspector in layout mode (data tab, ).
the year has to be a 4 digit value because of the centuries - yesr 15 could be 1915, 2015...
Make a custom menu, then change action of the menu to
Insert Calculated Result [
Let ( d = Get ( CurrentDate ) ;
Month ( d ) & "/" & Day ( d ) & "/" & Right ( Year ( d ) ; 2 )
I don't like making custom menu, can't duplicate standard menu
Thanks for everyone's input. I think the bottom line is that it is not possible to change the default so that the Ctrl - quick key stroke will input into a text field the mm/dd/yy format instead of the mm/dd/yyyy format.
yes - and it has to be that way, this was one of the year-2000 - issues. But it shouldn't really matter - one can have the date _displayed_ the way one likes, just for internal use, the year has to be in a 4-digit format
- ctrl- will enter the date into a field
- that field can be formatted/displayed in whatever way using the inspector
It seems you missed that he wrote "into a text field". I think he want to input the date (in some sentense, like "today is mm/dd/yy") for human readers, not as date field data (for finding, sorting).
exactly - did not pay attention to the fact that one can enter some text and the hit ctrl-
there is just one shortcut for entering dates )-:
not perfect - but maybe there is a workaround by using a macro utility that lets one create keyboard shortcuts. On OSX, there are some - and when searching for windows alternatives, there are also some
I just figured out that it's Nov., 11. today. Certainly not the day to do tests on this
Though at 11:11h, Swiss Carnival starts.
In Europe, dates are usually represented like 11.1.2015 and not 1/11/2015. Another issue with ctrl. '-'
On Windows, you can change the format using control panel (short format of date), but it seems only separator is affected. Year is always 4 digit and day of week is ignored.
If you select "French(Swiss)", there are "dd.MM.yyyy" and "dd.MM.yy", in FM the result is same (11.11.2015) but If you get slash, it may be misconfiguration.
I think we have to wait until tomorrow to more tests
entering a slash instead of a dash is an old problem with the Swiss localisation