VBA excel convert value

Question

I am using a connection to a CSV file to get the information in a XLS macro file and I am having the issue with this query:

DataQuery = "SELECT [LastName], [FirstName], [BadgeNum], IIF(IsNull([CaseDocs]), 0, [CaseDocs]),IIF(IsNull([CallCount]), 0, [CallCount]),  IIF(IsNull([DocRate]), 0, [DocRate])" & _
        "FROM [" & DataFileName & ".csv] WHERE CallCenterDescription='ECA' AND [LastName] LIKE '" & Sheets(1).Range("G1").Value & "%' AND DATEDIFF(dd,CONVERT(date, CONVERT(varchar(8), [Date]), 112),getdate())  <= " & Sheets(1).Range("G2").Value & ""

the problem is AND DATEDIFF(dd,CONVERT(date, CONVERT(varchar(8), [Date]), 112),getdate()) <= " & Sheets(1).Range("G2").Value & "" in the where clause:Undefined CONVERT function

Andrey Khmelev · Accepted Answer · 2017-08-15 18:56:56Z

1

you use different syntax for the same clause

CONVERT(date, CONVERT(varchar(8), [Date]), 112)

maybe should be

DATEDIFF(dd, date, getdate())

or

DATEDIFF(dd, [Date], getdate())

edited Aug 15, 2017 at 18:56

answered Aug 15, 2017 at 18:50

Andrey Khmelev

1,1718 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA excel convert value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related