Code: Select all
SELECT '' as '1/1/2020' --Returns 1/1/2020 as a column header
Code: Select all
SELECT '' as '1/1/2020' --Returns 1/1/2020 as a column header
Code: Select all
SELECT
'' as '1/1/2020'; --Returns 1/1/2020 as a column header
'' as '2/1/2020'; --Returns 2/1/2020 as a column header
'' as '3/1/2020' --Returns 3/1/2020 as a column header
Code: Select all
strSQL = "SELECT '' AS '" & d & ';"
Code: Select all
strSQL = "SELECT '' AS '" & DateSerial(Year(d), Month(d) + 1, 0) & ';"
Code: Select all
strSQL = "SELECT '' AS '" & Format(DateSerial(Year(d), Month(d) + 1, 0), "yyyy-mm-dd") & ';"