• This sounds a really simplistic question, but based on what you've said, it should just be:

    update xys set submitdate=NULL where id in ('1','2'.........'100')

    I feel I must be missing something as surely if you know how to set the rows to one value, you know how to set it to another...