What to use in Custom SQL field (see RH column):
MMM DD YYYY (Time) | CONVERT(VARCHAR(19),[Table: Field Date]) |
MMM DD, YYYY | CONVERT(VARCHAR(12),[Table: Field Date],107) |
MM/DD/YY | CONVERT(VARCHAR(11),[Table: Field Date],1) |
MM/DD/YYYY | CONVERT(VARCHAR(11),[Table: Field Date],101) |
MM-DD-YYYY | CONVERT(VARCHAR(11),[Table: Field Date],110) |
Example:
where [Table: Field Date] = [Assignment: Start Date]
