Hello,
does anyone know how to edit for date format? For example, when i pull in a text file, one of the field is date and it would be in yyyymmdd, however sometimes if the user doest create the text file correctly then the date would be entered in as mmddyyyy or some other incorrect date format. So what i want to do is, once the file is pulled into a table i want to create a query to catch if the format is NOT in yyyymmdd. Is there a way to do this? maybe a function or something? please assist.
thank you,
Summer
does anyone know how to edit for date format? For example, when i pull in a text file, one of the field is date and it would be in yyyymmdd, however sometimes if the user doest create the text file correctly then the date would be entered in as mmddyyyy or some other incorrect date format. So what i want to do is, once the file is pulled into a table i want to create a query to catch if the format is NOT in yyyymmdd. Is there a way to do this? maybe a function or something? please assist.
thank you,
Summer