What to use in Custom SQL field (see RH column):
YYYY/MM/DD | CONVERT(VARCHAR(11),[Table: Field Date],111) |
YYYYMMDD | CONVERT(VARCHAR(11),[Table: Field Date],112) |
YYYY.MM.DD | CONVERT(VARCHAR(11),[Table: Field Date],102) |
YYYY-MM-DD hh:mm:ss(24h) | CONVERT(VARCHAR(24),[Table: Field Date],120) |
Example:
where [Table: Field Date] = [Assignment: Start Date]
