Start a new topic

Address Date From default to today

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

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.

Thank you,
Omatic Support
Login or Signup to post a comment