Forum Discussion
BobF77845
Dec 27, 2023Copper Contributor
Custom date format
After setting the custom date format to mm/yy I typed 7/26 (for 2-digit month and 2-digit year) and expected to see 07/27, instead I get 07/23. What's wrong?
- SOLVED Just format as Number: 00/00 and entering 7/26 will yield 07/26. Even though I am entering a date, it must be entered as a number.
1 Reply
- BobF77845Copper ContributorSOLVED Just format as Number: 00/00 and entering 7/26 will yield 07/26. Even though I am entering a date, it must be entered as a number.