I'm running a routine in MS Access that extracts dates from a text field in a financial database. Once the date is extracted, I'm using DateValue() to convert into "mm/dd/yyyy" format in order to then execute calculations on the date (days remaining, days in future, days (in years), et cetera).
Problem: DateValue() converts 12/01/33 into 12/01/1933 instead of the expected 2033, for a bond maturing in the future.
Any suggestions?
Thanks
Problem: DateValue() converts 12/01/33 into 12/01/1933 instead of the expected 2033, for a bond maturing in the future.
Any suggestions?
Thanks
Last edited: