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?
- Dec 27, 2023SOLVED 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.
BobF77845
Dec 27, 2023Copper Contributor
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.