Cast external data

[Todd129]

Hello

I am importing external data with date format yyyymmdd that is an integer.

How do I cast this integer as a date after import?

Many thanks!

[blom0344]

cast ([YearMonthDay];date) where [YearMonthDay] is in the YYYYMMDD format