locked
Compare two dates from table Dynamics RRS feed

  • Question

  • I'm having problem with my little task. I have a table with information about two users who are working during this time. If this time intersect (for User 1 for instance) I need get a MESSAGE/ERROR about it. Can you explain how to do this? Thanks!!

    Image -> https://social.msdn.microsoft.com/Forums/getfile/1147311


    • Edited by Sv1N2S Thursday, October 19, 2017 10:20 AM
    Thursday, October 19, 2017 10:19 AM

All replies

  • Hi, 

    How can we know the date where the user works ? it's 2 Datetime fields like workBeginDate, workEndDate or something else ? 

    Kind Regards, 

    Moh

    Monday, October 23, 2017 1:26 PM
  • Check this:-

    https://stackoverflow.com/questions/325933/determine-whether-two-date-ranges-overlap


    Regards Faisal

    Monday, October 23, 2017 2:43 PM