General information
Category:
Coding, syntax & commands
Title:
Replacing years in a date field
Hey everyone,
I was wondering if there was an easy way to replace the year function in a field. What I have is a table with a field that contains dates. The problem though is that the dates begin in 1980 and end in 2002. The dates after the century mark are showing up as 1900, 1901, 1902, however. My question is:
How can I replace those dates that have 1900, 1901, 1902 with 2000, 2001, 2002. For example: Change 1/1/1901 t0 1/1/2001 in an efficient manner?
Any suggestions would be appreciated. THanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only