4 Replies Latest reply: Jan 15, 2015 5:12 AM by Mark O'Donovan RSS

    Two dates in a single table

    Sujan Janardhan

      Hi,

       

      I have an employees table which has hire date and termination date and I have to do analysis on both.I have also created a master calendar but was joing only to Term date so was not able to do analysis on Hire Date.Can you please let me know how to handle this kind of situation.I have read the canonical periods thread but did not understand it well.

       

      Thanks.