This content has been marked as final. Show 5 replies
Can any one please help me on below requirement.
I have to create a flag with completed,Not Completed and Outstanding records. Some training completion dates contains null like below.
completed --> When user completes the training within 30days from the Hire date
Not Completed--> When user Not completed the training within 30days from the Hire date
Outstanding --> When user has still time to complete from hire date out of 30days.
I have tried like below but getting Not completed for 04/06/2018. This employee has the deadline up to 04/07/2018 by adding 30days .Please help me to show outstanding.
if((Training Completion date-HireDate )<=30,Completed,Not Completed)
Thanks in advance.