Remove End date/change to 00/00/0000 on a Constituency in bulk

Hi all,

I'm having a mental block about how I did this a year ago and can't get it to work!

I need to keep a constituency active on accounts, but the end dates are now all in the past. I've tried all the options in the Manage Constituency Utility, but I can't get the end dates to change to 00/00/0000 (and therefore remain an active constituency). Removing and adding again, still results in an end date of today, even when I leave the field as 00/00/0000. 

There's over 2000 const records, so I'd rather not go through them manually to change them all! 

I know I did this last year, as I can see blank end dates on the constituency I was using for that year. I know I didn't do any fancy SQL work for it either and I don't remember doing it manually one by one...

What am I missing please?

Thanks,

Alison

Parents Reply Children
No Data