Thread: [Solved] Calculate total services of an employee by year, month and days
View Single Post
 
Old 03-07-2022, 12:12 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
What about adding a day to 'Last Day of Service' instead adding 1 to Datediff() days result? So e.g. instead of calculating Datediff's between January 1st and January 31th and adding 1 for days, you simply calculate all Datediff's between January 1st and February 1st!
Reply With Quote