Hi June, I am sorry to bother you with this again. I understand if you ignore!
I had to abandon development a few months back as things got busy but I have a little time and wanted to sort this out. It transpires that the above code (for automatically incrementing the date from one record to another) doesn't actually work after all. It behaves in a peculiar fashion:
Up until the 12th day of the month it increments properly but in the mm/dd/yyyy format - after that date in increments properly in the dd/mm/yyyy format (which is what I want). However, in both cases it only increments the next record: any records after that maintain the value of the increment, so on every alternate record I have to put in the correct date. To demonstrate an example:
Enter record 1: put in date 01/12/13, record 2 immediately updates the Catch-Date field with 12/02/13.
Enter record 2: record 3 automatically places 12/02/13 in the Catch Date field until I change it to 02/12/13 (then record 3 changes to 12/03/13)
So up until the 12th day of the month I have to change the date each time.
After the 12th, the same happens except that it no longer switches month and day around so as I enter record 2, the date is correct.
Any ideas?