I have the following fields:
Start Date [Date Type]
Duration [Text Type] (which for the moment is text as it could potentially be 3 months, 6 months, 1 year, 2 years... [currently empty so can change])
End [Calculation Type]
How do I make a calculation so that in the "End" Field it tells me when the contract will end?
I know the fault is in the Duration field, but don't know how I can set it up so that it will work and make sense and the calculation to work.
Thanks in advance for any help