# Date validation field problem and suggestion **URL:** \ **Category:** Uncategorized\ **Created:** [July 16, 2021, 6:19am UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121 "2021-07-16T06:19:14Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![maarten](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/maarten/32/33373_2.png) [@maarten](https://forum.manager.io/u/maarten)\ **Post date:** [July 16, 2021, 6:19am UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/1 "2021-07-16T06:19:15Z")
1. When I want to enter a payment for a purchase invoice that has been paid the same date as issues I copy the issuedate of screenshot 1 (formatted by manager as 7-6-2021). 2. After clicking “New Payment” and pasting the date into the payment date field, the date reverts to today’s date (16-07-2021) after leaving the field. This is because the date validation compells me to enter the date in dd-mm-yyyy format. Which means instead of copy and pasting I would have to change the pasted date by manually adding the 0’s so it becomes ‘07-06-2021’. Which tends to feel a bit tedious if you have to do that for 50+ invoices. **Proposed solutions** A. I would propose changing the date validation method to automatically add zeros for single digit month and day entries when they are left out. The user entered ‘7-6-2021’ becomes ‘07-06-2021’ after validation. This also makes the date entry process less error prone when users enter it like this and go to the next field without noticing the auto-correct resulting in incorrect dated documents. B. As the default form date format is DD-MM-YYYY, it makes sense to also apply that when displaying dates in [manager.io](http://manager.io) (like the one in screenshot 1) ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/0/f05dbe0804d291f32d1a1e7356a351830c01f069.png) ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/b/7b4ab581c25a3b07ef5f64ecd8c79ca8b4714e44.png) ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [July 16, 2021, 7:21am UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/2 "2021-07-16T07:21:50Z")
Not long ago Manager used to tolerate omitted zeros in dates but I don’t know what happened to that. But basically, you’re right, either the system applies dates consistently or tolerate some benign inconsistencies. ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [July 16, 2021, 2:14pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/3 "2021-07-16T14:14:00Z")
What version are you using? Your screen shots appear to be from either two different versions or an obsolete version, because they show two different date formats. The program shows matching date formats for the screens you illustrated: ![Screen Shot 2021-07-16 at 8.01.48 AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/d/b/dbfe9074e5637ccb5e4e1b040ae110e66aef5f5f.png) ![Screen Shot 2021-07-16 at 8.02.11 AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/a/fa09fbc6b5c31aa7dd6e03c214b6a43794ea7a9d.png) Your process seems more cumbersome to me than just editing the date on the payment would be, but it works correctly on the current version of the program (v21.7.24). ---
**Author:** ![maarten](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/maarten/32/33373_2.png) [@maarten](https://forum.manager.io/u/maarten)\ **Post date:** [July 16, 2021, 2:21pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/4 "2021-07-16T14:21:33Z")
I’m using the latest version of Manager Desktop (21.7.24) on Windows 10 This is what it looks like on my machine: ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/4/7484e6356f90658e3d6a15bec586c5cfd1eee5e7.png) ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [July 16, 2021, 2:38pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/5 "2021-07-16T14:38:02Z")
Post a screen shot of your Date & Number Format page under the Settings tab. It should look like this, based on what you have written: ![Screen Shot 2021-07-16 at 8.34.50 AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/6/1/61047be8fc5291852d4ce7422767e42ce233abaf.png) And your Sales Invoices listing should look like this: ![Screen Shot 2021-07-16 at 8.37.09 AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/9/795005038197863d7ec8f59b3b0f8e08ee8349a7.png) ---
**Author:** ![maarten](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/maarten/32/33373_2.png) [@maarten](https://forum.manager.io/u/maarten)\ **Post date:** [July 16, 2021, 2:40pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/6 "2021-07-16T14:40:37Z")
![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/a/7ace3560f05d5a09860cf25f5c4fb8f23fb288b4.png) ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/c/7/c74e56149a6adb97ba79e448542da59a21171574.png) ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [July 16, 2021, 2:45pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/7 "2021-07-16T14:45:34Z")
Must be a Windows problem. My examples are from a Mac. ---
**Author:** ![maarten](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/maarten/32/33373_2.png) [@maarten](https://forum.manager.io/u/maarten)\ **Post date:** [July 16, 2021, 2:54pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/8 "2021-07-16T14:54:25Z")
Could be, maybe somebody else with a windows computer can verify this. I hope Lubos can fix this in the next update. Thanks for the response though! ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [July 16, 2021, 3:16pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/9 "2021-07-16T15:16:34Z")
I am using 21.7.22 Date & Number Format settings ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/4/c/4cd94d7c31d3a3134535afb21305fa75b24a3939.png) Sales Invoices ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/4/5440968ef5f049ed317db91d028877025a554754.png) ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [July 16, 2021, 3:18pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/10 "2021-07-16T15:18:11Z")
oops - different number format ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/d/9db7701fca1b760c719b3e10d383b1e766c91862.png) Dates still look good ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/4/e/4e48440364840f9056f9d860c8913ff3099dd2ec.png) ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [July 16, 2021, 3:23pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/11 "2021-07-16T15:23:35Z")
And with version 21.7.24, Windows 10 desktop 64-bit version - all good Are your Windows regional settings set correctly? ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/b/0/b04eb1891cedd9d873bf559197ee63e8957feff3.png) ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/6/961dfa2046d54be3aed196acf094d3866a47fd0e.png) ---
**Author:** ![maarten](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/maarten/32/33373_2.png) [@maarten](https://forum.manager.io/u/maarten)\ **Post date:** [July 16, 2021, 4:10pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/12 "2021-07-16T16:10:57Z")
Yes, changing my Windows regional settings + setting the manager date settings to another value and then returning fixed the issue. The dates now show up like 12-06-2021. Cheers Joe! That only leaves my second issue: 1. After clicking “New Payment” and pasting the date into the payment date field, the date reverts to today’s date (16-07-2021) after leaving the field. This is because the date validation compells me to enter the date in dd-mm-yyyy format. Which means instead of copy and pasting I would have to change the pasted date by manually adding the 0’s so it becomes ‘07-06-2021’. Which tends to feel a bit tedious if you have to do that for 50+ invoices. **Proposed solutions** A. I would propose changing the date validation method to automatically add zeros for single digit month and day entries when they are left out. The user entered ‘7-6-2021’ becomes ‘07-06-2021’ after validation. This also makes the date entry process less error prone when users enter it like this and go to the next field without noticing the auto-correct resulting in incorrect dated documents. Like [Ealfardan](https://forum.manager.io/u/Ealfardan) said, it would be great to include the option to tolerate omitted zeros in dates (again). ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [July 16, 2021, 4:46pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/13 "2021-07-16T16:46:27Z")
> [@maarten](#): > > That only leaves my second issue: No, because the dates you are copying and pasting are now in the correct format. Understand that there used to be more date formats, including D-M-YYYY (allowing single digits). To reduce confusion, the number of options was reduced when the date picker was changed to the current one. This was the subject of an article in the April 2021 newsletter. ---
**Author:** ![maarten](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/maarten/32/33373_2.png) [@maarten](https://forum.manager.io/u/maarten)\ **Post date:** [July 16, 2021, 8:13pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/14 "2021-07-16T20:13:46Z")
Yes, for copying and pasting the issue is solved. There still is some error proneness when entering a purchase invoice date manually. If entered like 1-6-2021 + tab , the date would be reset to the current date. Since manager is only working with the DD-MM-YYYY format in this setting it seems to me that it would be nice if validation results in reformatting the entered date to 01-06-2021 instead of resetting to the current date. ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [July 16, 2021, 8:19pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/15 "2021-07-16T20:19:06Z")
or 06-01-2021 date formats are a minefield ---
**Author:** ![Doronto](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/doronto/32/32376_2.png) [@Doronto](https://forum.manager.io/u/Doronto)\ **Post date:** [July 16, 2021, 8:25pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/16 "2021-07-16T20:25:58Z")
A little problem as i saw can’t paste a date. To change the date i have to edit the date on field one by one. like day, month year or select from the calendar. Date display style may be depends on the system date style. Better first set the system date with your desired format. like dd/mm/yy or mm/dd/yy. ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [July 16, 2021, 9:16pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/17 "2021-07-16T21:16:17Z")
> [@Doronto](#): > > i saw can’t paste a date This is not true. You just have to paste it in the correct format. ---
**Author:** ![Doronto](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/doronto/32/32376_2.png) [@Doronto](https://forum.manager.io/u/Doronto)\ **Post date:** [July 16, 2021, 11:15pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/18 "2021-07-16T23:15:04Z")
i have tried. Well i will try again. ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [July 5, 2026, 8:19pm UTC](https://forum.manager.io/t/date-validation-field-problem-and-suggestion/36121/19 "2026-07-05T20:19:27Z")
Closed on July 5, 2026, 8:19pm UTC Uncategorized topics older than 3 years with no recent activity