Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement