Can you use tableau RAWSQL_DATE() function? Something like....
First of all convert your date to DateString in this format : "MM/DD/YYYY"
So your [DateString] will be like "7/26/2011" then use following formula
RAWSQL_DATE("TO_DATE(TO_CHAR(%1), 'MM/DD/YYYY')", [DateString])
Hope this helps!!
Thanks Nikunj! That works when I use it within a calculated field in Tableau but I am trying to find a way to convert it in my Custom SQL Query since I am trying to do a cross-database join...
Cross-database join? are you trying to join on date column from two different database? and that two data-sources are different? i.e oracle and sql server? Apologies if I miss understood.
Can you post your proposed query?