Now() function

[shexe]

Good Morning - I need to insert a DateTime stamp in an update query. I know that I need the Now() function but I am not sure where and I keep syntax erroring out. The code is listed below, can someone please show me where?



INSERT INTO IT_Staff_Allocation_Snapshot ( Scenario, TemplateOwner, Project, BudgetWorkbook, ResourceName, Correction, January, February, March, April, May, June, July, August, September, October, November, December, UpdatedDateTime )
SELECT IT_Staff_Allocation_2010.Scenario AS Scenario, IT_Staff_Allocation_2010.TemplateOwner, IT_Staff_Allocation_2010.Project, IT_Staff_Allocation_2010.BudgetWorkbook, IT_Staff_Allocation_2010.ResourceName, IT_Staff_Allocation_2010.Correction, IT_Staff_Allocation_2010.January, IT_Staff_Allocation_2010.February, IT_Staff_Allocation_2010.March, IT_Staff_Allocation_2010.April, IT_Staff_Allocation_2010.May, IT_Staff_Allocation_2010.June, IT_Staff_Allocation_2010.July, IT_Staff_Allocation_2010.August, IT_Staff_Allocation_2010.September, IT_Staff_Allocation_2010.October, IT_Staff_Allocation_2010.November, IT_Staff_Allocation_2010.December, IT_Staff_Allocation_2010.UpdatedDateTime
FROM IT_Staff_Allocation_2010;

Thanks,
shexe

[shexe]

Got it. See below.
INSERT INTO IT_Staff_Allocation_Snapshot ( Scenario, TemplateOwner, Project, BudgetWorkbook, ResourceName, Correction, January, February, March, April, May, June, July, August, September, October, November, December, UpdatedDateTime )
SELECT IT_Staff_Allocation_2010.Scenario AS Scenario, IT_Staff_Allocation_2010.TemplateOwner, IT_Staff_Allocation_2010.Project, IT_Staff_Allocation_2010.BudgetWorkbook, IT_Staff_Allocation_2010.ResourceName, IT_Staff_Allocation_2010.Correction, IT_Staff_Allocation_2010.January, IT_Staff_Allocation_2010.February, IT_Staff_Allocation_2010.March, IT_Staff_Allocation_2010.April, IT_Staff_Allocation_2010.May, IT_Staff_Allocation_2010.June, IT_Staff_Allocation_2010.July, IT_Staff_Allocation_2010.August, IT_Staff_Allocation_2010.September, IT_Staff_Allocation_2010.October, IT_Staff_Allocation_2010.November, IT_Staff_Allocation_2010.December, Now() AS UpdatedDateTime
FROM IT_Staff_Allocation_2010;