Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to change date to text

When I import data the column A loads automatically as date.

This is the script:

Date(Date#([Column A], 'MM.DD.YYY')) AS [Culumn A]

However this column A doesn't contain dates but text. How can I change it to text?

1 Reply
Anonymous
Not applicable
Author

Oh  I found it. Just remove the part 'Date(Date#([Column A], 'MM.DD.YYY')) AS '.