General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2000 Server
Hi Rick,
>Like I said, it just depends on how accurate you want to be. GOMONTH can change the day of the month when beginning from a date with a day of 29, 30, or 31. To be fully accurate you need to adjust for this.
Noticed the checking in your code for this. Thanks for the explanation.
>I used my class to run some examples here, but the results can be derived and checked easily enough by hand. For example, 09/13/1868 plus 33 years = 09/13/1901, plus 6 months = 03/13/1902, plus 18 days = 03/31/1902. If you start with 09/12/1868 you end up with 03/30/1902.
"by hand" is my immediate problem ;-) I've got over 30K records to massage.
>If you can live with a little variance in the result then certainly the simpler solutions are okay, though.
OK, I'm using Sergey's code to scan the data first, running the result through your class, then adjusting the "DOB" with any variance. See any problems with this approach?
Previous
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