Auto enter a date for a new record via web PHP api: Date format YYYY/MM/DD

Workers submit a new timesheet online every other week. The timesheet (addrecord.php) auto-enters the 'Current Pay Period' (Period Ending) but workers must be able to change the date.

The best way I know to auto-enter a value for a new record is through a valuelist (our secretary changes the value every pay period). (Anything else would require a person to create the record first and then get the value through a relationship, at least in my limited experience).

Thanks Johan- our files were setup originally about 20 years ago (and have expanded/changed much since then). As the link (Set Use System Formats) says, we can't change the stored format (mdy).

> Each FileMaker Pro database file stores the date, time, and number formatting of the computer on which the database was created. These regional settings may be different from the system formats currently set on your computer.