Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hello i have date from that i want to calculate current shift like system date is 4/3/2018 2:47pm is current time and then find out that shift from
Shift Timing
=================
Shift A: 6AM to 2PM
Shift B: 2PM to 10PM
Shift C: 10PM to 6AM
how to find that shift means current shift,current shift-1,current shift -3.......up to 15th shift....,,,,
suggest some way....
Solved! Go to Solution.
You need to calculate start time of current shift using GETDATE() and IF statement.
From there, it's easy to calculate shift order using start time of current shift -8 hours,-16 hours,-24 hours, etc. again using IF statement.
You need to calculate start time of current shift using GETDATE() and IF statement.
From there, it's easy to calculate shift order using start time of current shift -8 hours,-16 hours,-24 hours, etc. again using IF statement.
Hiii,
Can u explain more!!
Regards ,
Pooja
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |