Re: [Emerald] Mass Updating Payments

Josh Hillman ( (no email) )
Fri, 28 May 1999 18:52:47 -0400

>Darin Spence wrote:
>> Is there a quick query that can be written to change the payment date on all
>> payments made today? I need the payment date to be 6/2/99 instead of
>> 5/28/99.
From: Dale E. Reed Jr. <>
>> Basically, because of the long weekend, we want all of our payments that
>> were put in today to look like they were put in on 6/2/99 so Emerald matches
>> up with out deposit that goes to the bank. Our next deposit is 6/2/99.
>Update Payments
>Set Date = '6/2/99'
>Where Date = '5/28/99'

Payments.Date is not specific to midnight though (at least with 2.1) so that might not catch any payments.

update payments
set date = '6/2/99'
where date >= '5/28/99' and date < '5/29/99'

That'd set the all of those dates to 6/2/99 at midnight.