Wierd issue with Filter a DataSet not working correctly

Get Help
1

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 :

dtDay=DAYNAME(CURDATE())

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()) ?

regards

2

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