Importing database with date field

I import a file of Standing Orders into my Orders File that then calculates the invoice number and shipping date. I set the Date field in Standing Orders to text and enter “Tuesday” or “Friday”, append it and Pan X converts the text to the correct date for the current week. Very cool and easy.