Joined: 23 Jan 2012
Location: United States
Online Status: Offline
Posts: 2
Topic: 24 hour daily time frame Posted: 23 Jan 2012 at 8:32am
Is there a way to have Crystal calculate time span between 7pm to 7pm, as one day. In trying to measure our split shipments where I work. Whenever we close a manifest, and 1 carton shipped at 8pm and the other at 8 am the next day, my current formula calcuates it as a split. Cartons shipped on multiple days.
The change I've been asked to make, is that if the cartons shipped within the 7-7 time frame, it's shouldn't calculate as a split. Is this possible?
Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Posted: 23 Jan 2012 at 11:27am
now that i think about my previous post doesn't solve your problem. so the only way that i can think of is kind of manual formula like if {table.date carton shipped} in datetime(2011,1,1,7,0,0) to datetime(2011,1,2,7,0,0) then "2011/1/2"else if {table.date carton shipped} in datetime(2011,1,2,7,0,0) to datetime(2011,1,3,7,0,0) then "2011/1/3" ...ETC
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 23 Jan 2012 at 3:40pm
Try creating a formula where you subtract 7 hours from the shipment datetime. This means that any shipdate that's between midnight and 7 am will actually look like it's the previous day. Use this formula for your calculations when checking for split shipments.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
Is there a way to have Crystal calculate time span between 7pm to 7pm, as one day. In trying to measure our split shipments where I work. Whenever we close a manifest, and 1 carton shipped at 8pm and the other at 8 am the next day, my current formula calcuates it as a split. Cartons shipped on multiple days. 
IP Logged
