Joining data from 2 dates

[BigglesUK]

Hello, 1st posting here and im hoping i can have some light shed on my problem.

My company works in shifts, and data can be entered up to 4 am in the morning.

Unfortunatly our new erp system only works by 12am to 12am even though we class up to 4am as the same day.

I need to be able to manipulate the dates the data comes for days. For example. Yesterday for us in data wise is:
28/6/05 4:00:00 to 28/6/05 23:59:59 +
29/6/05 00:00:00 to 29/6/05 3:59:59

thats the 24 hour period I need to pull data off for. The data lies in a table called WUKTMPKNIFECUTTERTABLE in the field DLVDATE and looks like this format 12/04/2005 12:00:00AM

Any help that someone could give me would be greatly appreciated.

 

[rosemaryl]

Dear BigglesUK,

Do you need a formula for selection of data or for grouping of data or for both?

Crystal version and database is always nice to post in your questions.

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[BigglesUK]

hi rosemaryl thanks for getting back to me. Im going to be doing both with it. Im running Crystal Reports 10 Developer Edition. My database name is Axap_test.

thanks,

Andrew