Displaying Today's Date in VBA Select statement

[irunergoiam]

I want the current date to display (see Date in Red below). I have tried the following, but can't seem to get it to work:

'#Date()#'
#'Date()'#
'#Date#'
#'Date'#

sSQL = " SELECT [LastName] & ', ' & [FirstName] & ' ' & [MiddleName] AS [FullName], [1STARTRequestLog].[LastName] & ', ' & [1STARTRequestLog].[FirstName] & ' - ' & [1STARTRequestLog].System & ' - ' & #Date# AS [START Subject]," & _

Any ideas??? I get a "Runtime Error '13': Type Mismatch" error.

Thanks in advance for your guidance on this.

 

[boblarson]

For the date formula you don't need to use the octothorpes.

Just:

sSQL = " SELECT [LastName] & ', ' & [FirstName] & ' ' & [MiddleName] AS [FullName], [1STARTRequestLog].[LastName] & ', ' & [1STARTRequestLog].[FirstName] & ' - ' & [1STARTRequestLog].System & ' - ' & Date() AS [START Subject]," & _

should do the trick