I have a file to import that the address Date From is blank about 50% of the time. I want to keep the dates that are in the file and default the blank dates to today's date. Is that possible?
1 Comment
A
Amanda Allen
said
over 5 years ago
Hi Therese,
I would recommend sorting your file by that date column and then pasting today's date where it's blank.
You could create a dictionary to translate blank into a date, but you aren't able to specify "today's date". The dictionary would need to be updated everyday with the actual date.
Please let me know if you have any other questions.
Therese Morris