Jan,
Here's how ...
UPDATE tablename SET datecolum = (ADDYR(datecolumn,-100))
That's all there is to it!
Have fun!
Razzak
At 12:18 PM 12/3/2020, jan johansen wrote:
All,
Had a case where some dates blew up.
Basically the year is 100 years in the future. But not all of them.
So how do I subtract 100 years?
Jan
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/0Lu7BQ-1k4lGi3fks-011Uxw%40mrelay.perfora.net.
