Duh! I need another cup of coffee!
Thanks Razzak From: "A. Razzak Memon" <[email protected]> To: [email protected] Date: Thu, 03 Dec 2020 12:21:17 -0500 Subject: Re: [RBASE-L] - Date function 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. -- 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/WC20201203173206.020002%40jjcalibrations.com.
