- Edited
I read the question on the IRC yesterday from Alan about how to format dates in rowfilters.
This is what I found in our existing code:
in csharp\ICT\Petra\Server\lib\MFinance\Common\Common.Tools.ExchangeRates.cs:
rates.DefaultView.RowFilter = ADailyExchangeRateTable.GetDateEffectiveFromDBName() + "<= #" +
ADateEffective.ToString("yyyy-MM-dd") + "#";
That should work in every culture.