Re: dates in Emerald
Josh Hillman ( (no email) )
Mon, 15 Dec 1997 20:31:26 -0500
> From: Dale E. Reed Jr. <daler@iea.com>
>
> Josh Hillman wrote:
> >
> > Are there any plans for future releases of Emerald to have Invoice.Date
> > include the time as well as the date (e.g. Dec 15 1997 3:42PM instead of
> > 12:00AM)? When presenting invoices/payments/charges, etc. in order by
> > eventdate/time, these get out of their correct order. The most common
> > place where this occurs is in the History area of an MBR. If there are
> > several invoices/charges/payments for an individual MBR in one day, these
> > events are displayed in the wrong order because the Invoice.Date doesn't
> > track the time that it was created.
>
> In all my databases here, it does? Invoice.Date is a DateTime, which
> is accurate to the second. It may be that the 2.1 client is using the
> local date, rather than GetDate() to producde the date. All versions
> of Emerlad 2.2 and higher use GetDate() for stamps, rather then the
> local computer.
I should have been a bit clearer on that I guess. The db stores date and
time like all other date/time fields throughout the db. All Invoice.Date
entries are at midnight though ('Dec 15 1997 12:00AM' instead of 'Dec 15 1997
2:54PM' or whatever time it was).
> Interesting side note, what about the MasterAccounts entry? VOIDING an
> invoice changes the MasterAccounts balance field. SHould the LastModify
> be updated there as well.
Good point. Without putting too much thought into it, I'd think that it
shouldn't be modified, but then again, I never pay attention to the balance
in the MBR anyway (most of our users' balances according emerald are wrong
anyway. Anytime I look at the modify date / user (which by the way, the
PM/AM can't be seen in E 2.1.11), I have in my mind, the last time that one
of our people made a change to the MBR, such as an address change or
something.
Josh