Yes, but you need some care here as (theoretically) you might have dates recorded as EBA (thus starting 2350BC) and also dates "manually" entered as 2350BC (which you would not want to alter). HBSMR differentiates between these, and you need to take account of this when bulk-updating.
Ask Keith to help prepare the required SQL (I'm away in sunny Bedford).
From: Issues related to Historic Environment Records on behalf of Helen Wells
Sent: Tue 23/03/2010 12:01
To: [log in to unmask]
Subject: Bronze Age dates query
I just noticed that my Bronze Age start date and my Early Bronze Age
start date don't match - the EBA starts in 2350BC but the Bronze Age
starts in 2500BC. Presumably the EBA is supposed to start in 2500BC?
My data has a weird gap!!
If I change that date (assuming that it's supposed to be 2500BC) then
can I get HBSMR to alter all the dates that were entered as 'Early
Bronze Age' to change to the new 2500BC date instead of 2350BC?
Assistant Planning Archaeologist/Historic Environment Record Officer
Leicestershire County Council
Leicestershire County Council - rated a 'four-star' council by the Audit Commission - Council of the Year 2009
Important notice: Leicestershire County Council is changing its personal e-mail address format. Please ensure that any personal Leicestershire County Council e-mail addresses you hold are updated as soon as possible so that your e-mails continue to be delivered correctly. Group e-mail addresses such as [log in to unmask] are not changing.
This e-mail and any files transmitted with it are confidential. If you are not the intended recipient, any reading, printing, storage, disclosure, copying or any other action taken in respect of this e-mail is prohibited and may be unlawful. If you are not the intended recipient, please notify the sender immediately by using the reply function and then permanently delete what you have received.
Incoming and outgoing e-mail messages are routinely monitored for compliance with Leicestershire County Council's policy on the use of electronic communications. The contents of e-mails may have to be disclosed to a request under the Data Protection Act 1998 and the Freedom of Information Act 2000.
The views expressed by the author may not necessarily reflect the views or policies of the Leicestershire County Council.
Attachments to e-mail messages may contain viruses that may damage your system. Whilst Leicestershire County Council has taken every reasonable precaution to minimise this risk, we cannot accept any liability for any damage which you sustain as a result of these factors. You are advised to carry out your own virus checks before opening any attachment.