change to date format in Make Table Query (1 Viewer)

[asp_learner]

Because of a query where I am avoiding duplicates, (Date3: IIf([Last]=[Date1],"",[Last])), I have a date field that is in text format instead of date format. How can I write the query to save it as date format.

Thanks,
Eva

 

[asp_learner]

I finally got it to work. I revised the query so that I don't have a null value.