Hi,
My data contains 3 columns for start date, end date and production.
The date formats are mm/dd/yyyy hh:mm
Our fiscal days are between 6:00am to 6:00am i.e. production made during Jan 1, 2015 6:00am (Start time) to Jan 2, 2015 6:00am(End time) is recorded as production made for Jan 1 2015. If end time was Jan 1, 2015 6:00am then that would be recorded as production for Dec 31, 2014.
Sample Data
Start_Time_Full End_Time_Full Production needed Answer 5/30/2015 6:39 5/30/2015 6:45 6 5/30/2015 8/18/2015 14:38 8/18/2015 14:42 4 8/18/2015 9/11/2015 2:03 9/11/2015 2:07 4 9/10/2015 9/11/2015 16:50 9/11/2015 16:58 8 9/11/2015 9/14/2015 5:45 9/14/2015 6:00 2 9/13/2015 9/14/2015 14:19 9/14/2015 14:26 7 9/14/2015
I want my query to just return me the fiscal date in a column; but that date has to meet the criteria mentioned above.
Thank you in advance for your help!!