I need to calculate a filed named: ContractOpenBeginDate
The concetp of the field is as follows:
ContractOpenBeginDate = to Today's date if in the middle of contract (start & end dates) OR if contract has not started yet OR NULL if Contract is closed (contract end date is in the past)
The fields I will use are: Today (GETDATE()), ContractStartDate, ContractEndDate
I know this is a CASE statement, but I need help in writing the code if possible because I have not used these type of combinations before.
Any help would be great.
Thank you very much fro your help.