Converting text value into date within query (1 Viewer)

FrozenMana

Registered User.
Local time
Today, 14:34
Joined
Aug 10, 2015
Messages
27
My first time using this database as my coworker has fallen seriously ill and I am unable to ask them for help.
There is a query that is supposed to translate a text value into a date value. The value for the date is written in a 1yymmdd format in the file/table being used.

The following is the SQL query that is set up:
Code:
SELECT qryValidZips.ZipCode, EMP013.HSAHBCD, [COLOR="Red"]Left([HSACHDT],10) AS Expr1[/COLOR], EMP013.HSAOCAT
FROM qryValidZips, qryActiveHubs INNER JOIN (EMP013 INNER JOIN tblRefCoverageCategory ON EMP013.HSAOCAT = tblRefCoverageCategory.CovCatg) ON qryActiveHubs.HBMHBCD = EMP013.HSAHBCD
WHERE (((qryValidZips.ZipCode) Between [hsafrzp] And [hsatozp]))
GROUP BY qryValidZips.ZipCode, EMP013.HSAHBCD, EMP013.HSAOCAT, EMP013.HSASTAT
HAVING (((EMP013.HSASTAT)="ACTV"));


however the query is now giving the error message:
Code:
Undefined function 'Left' in expression
 

James Deckert

Continuing to Learn
Local time
Today, 13:34
Joined
Oct 6, 2005
Messages
189
Check Paul's suggestion, but also make sure the VBA compiles ok. Also "compact and repair" the DB.
 

FrozenMana

Registered User.
Local time
Today, 14:34
Joined
Aug 10, 2015
Messages
27
I thought I updated all of the references. Thank you!
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 11:34
Joined
Aug 30, 2003
Messages
36,118
Happy to help!
 

Users who are viewing this thread

Top Bottom