Wierd issue with Filter a DataSet not working correctly

Dear all,

I have a dataset when I have a day field with is enter as the list of week days but in French as below

Lundi, Mardi, Mercredi, jeudi, Vendredi

Then I try to filter my dataset by getting the current day name of current day.
So in my dataset filter I enter the following :


By doing so it return no records at all, if I change it hard coded as below :

dtDay=‘Mardi’ then it return correct records

How can I get same result using DAYNAME(CURDATE()) ?


As I replied in one of your other threads on this, DAYNAME() will return an English date by default.