i need to build a query with the convert function in the select and in the group by statement, for example:
, CONVERT(Datetime,DEPOSITS.CREATEDDATE,101) AS date_conv
GROUP BY ** CONVERT**(Datetime,DEPOSITS.CREATEDDATE,101)
now, i dont see an option for that in the query builder online (i mean the visual tool).
how can i let my data guy (who does not program sql) to do that manipulation.