price list line effective data and time
Hello; a question for the group.
If we end-date an existing item on an existing price list today ("09/30/14") and set up a new line for that same item with a start date of tomorrow ("10/1/14")... we seem to run into problems with "what those 2 dates mean"...
When we SQL-query the records, the 9/30/14 end date shows timestamp 00:00:00. The 10/1/14 start date also shows timestamp 00:00:00. Technically, if these stamps are relevant here, then the "24 hour day" of 9/30/14 has no effective price...!
(ie, the price ends at the moment 9/30 begins on the clock; 00:00:00. The new price doesn't start until the moment 10/1 begins on the clock, 00:00:00.)
0