Hi,
I requested help from you on Dates in tables and in excel
my requirements change a bit a i need a new approach
i have a spreadsheet with a date format
DDMMYY which is in a text format
i want to import the spreadsheet and immediately write to the table my new date format DD/MM/YY to be able to run different queries from the date field
the format is effeminately in a DDMMYY format and I would like to keep it in the DD/MM/YY format
my problem now is when i run a update query to the table with my date formatted to DD/MM/YY
the date is inverted
Excel - Should look like -
301119 - 30/11/19 - imported as 19/11/30
i tried
Expr1: IIf(Len([Installation Date (DDMMYY)])>5,Left([Installation Date (DDMMYY)],2) & "/" & Mid([Installation Date (DDMMYY)],3,2) & "/" & Right([Installation Date (DDMMYY)],2),"0" & Left([Installation Date (DDMMYY)],1) & "/" & Mid([Installation Date (DDMMYY)],2,2) & "/" & Right([Installation Date (DDMMYY)],2))
but still no luck
I requested help from you on Dates in tables and in excel
my requirements change a bit a i need a new approach
i have a spreadsheet with a date format
DDMMYY which is in a text format
i want to import the spreadsheet and immediately write to the table my new date format DD/MM/YY to be able to run different queries from the date field
the format is effeminately in a DDMMYY format and I would like to keep it in the DD/MM/YY format
my problem now is when i run a update query to the table with my date formatted to DD/MM/YY
the date is inverted
Excel - Should look like -
301119 - 30/11/19 - imported as 19/11/30
i tried
Expr1: IIf(Len([Installation Date (DDMMYY)])>5,Left([Installation Date (DDMMYY)],2) & "/" & Mid([Installation Date (DDMMYY)],3,2) & "/" & Right([Installation Date (DDMMYY)],2),"0" & Left([Installation Date (DDMMYY)],1) & "/" & Mid([Installation Date (DDMMYY)],2,2) & "/" & Right([Installation Date (DDMMYY)],2))
but still no luck