Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing year in date field
Message
 
To
06/01/2017 13:06:53
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01646327
Message ID:
01646409
Views:
106
>>>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)
>
>It might also be a good precaution to add filtering clause -- just in case (e.g. FOR YEAR(date)==2016 ). Yes, I'm aware that Colin di indeed state "all records" -- but that could be based on viewing a filtered list rather than the unfiltered table (yep, ran into that sort of thing once before with a customer).

Thanks
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Previous
Reply
Map
View

Click here to load this message in the networking platform