SQL Select statement with Date as
I'm pulling data into Excel using a SQL statement in VBA. I'd like to
pull an [updatedate] field and have it formatted in the format yyyy -
mm. I'm not sure how to do this however. I basically have this set
up right now.
Statement = "SELECT Insertby, Campaign, Resolution1, " & _
"Resolution2, Resolution3, Stage, MonthlyCost, " & _
"ProspectId " & _
I'd like to add into this something along the lines of
Format(UpdateDate,"yyyy - mm") AS UpdateMnthShrt
I'm not sure how to set the UpdateDate portion of the statement. Any
help would be GREATLY appreciated.
Thanks
Paul
|