Hi All,
I have created Date field control in form and changed the format like DD/MM/YYYY.
It's showing correct only
But when I try to filter by that date format(DD/MM/YYYY), throwing error
Throwing error like this. I thought it consider the format MM/DD/YYYY
Any idea about this how to filter DDMMYYYY format in that filter.
Thanks,
Ashok.
I found that it works based on the "Date, time, and number format" given under user options. Select this as "en-GB" and check. For "en-GB" its accepting data format as DD-MM-YYY. But I am not sure what are all the places it will impact.
If you change that to en-GB than in all other places Date format will be changed to DD-MM-YYY.
Thanks,
Girish S.
As far as I know there is no option in the front end to select date format.
So as a try you can create a new Date EDT and set the Date format there and then map that EDT to your date field in the table.
This is just workaround.
If it doesn't work, then I think there is no other options to change filter property to accept the selected date format.
Thanks,
Girish S.
Hi Girish,
I have changed the Date format in form design control already
Thanks
Hi Ashok,
Where you changed the date format?
If you changed the data format in the EDT only. Try changing the Date format in form design control also and check.
Thanks,
Girish S.
André Arnaud de Cal...
292,031
Super User 2025 Season 1
Martin Dráb
230,868
Most Valuable Professional
nmaenpaa
101,156