What Function to use?
I have two date fields, start date and end date. The end date field can be the same value of the start date, based on the value of another field, type. I would like to have the end date, reference the start date when type=ER. Also for type that does not equal ER, I would like that to be the date that is entered and not refer to the start date.
I don't know where to start or what function to use. Any tips would be much appreciated. Thanks.