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. <daler@iea-software.com>
>> 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.
Josh