Message
From
06/01/2017 12:44:56
To
06/01/2017 06:07:28
Miscellaneous
Thread ID:
01646327
Message ID:
01646355
Views:
47
>>>I have a table with a field called date - the year is 2016 on all records - how do I change it to 2015 on all records
>>>
>>>A simple question - I have forgotten how to do this
>>
>>replace all date with gomonth(date, -12)
>
>2016 was a leap year... I'd do manual check on existance of Feb 29 ;-)
why??
GOMONTH(DATE(2016,2,29),-12) returns february 28, 2015 correctly
>>>
>>>A simple question - I have forgotten how to do this
>>
>>replace all date with gomonth(date, -12)
>
>2016 was a leap year... I'd do manual check on existance of Feb 29 ;-)
why??
GOMONTH(DATE(2016,2,29),-12) returns february 28, 2015 correctly
Peter Cortiel