CAST() instead of CONVERT() for the "Date Function" for better performance
The YF internal date function for the reports and filters uses the T-SQL "CONVERT":
convert(datetime, convert(varchar(20), "tablename"."Date", 112), 112)
We replaced it with the ANSI "CAST":
cast(cast("tablename"."Date" as date) as datetime)
And we found that it was at least twice as fast!
So my request is for YF to use the CAST() function instead of the CONVERT() function in the Prepare screen's "Date Function" feature.