I have two sql statements that pull similar fields from different tables.
One sql statement just declares empty values so that it will have the same number of columns as another sql statement.
In one of my sql statements I return a date from the MSAccess database.
In the other sql statement I need to return the current date.
How would I do this?
Below is the sql statement that I need to include the current date... See Date() as DateCreated.
str = "SELECT 0 AS TaskCarsDetailID, TaskDetailsLU.TaskDetailsID, 0 AS Completed, " _
& " TaskDetailsLU.TaskDetails, '""' AS TaskCarNotes, Date() AS DateCreated" _
& " FROM TaskDetailsLU where TaskID = " & miTaskID & ""