Forum Discussion

Iron Contributor

Sep 21, 2018

Create a list view filtered by a date column?

Hi, I need to create a view for a list that contains a custom column of type date. The format is in swedish, its mean: 2018-09-21 The view has to show all items between 2018-09-01 and 2019-06-30 ...

Brass Contributor

Sep 22, 2018

Hi, Americo Perez

If the regional settings are set to swedish you have to use [IDAG] instead of [TODAY]

Americo Perez

Iron Contributor

Sep 22, 2018

Thanks,

but it still saying that the date format is not supported

Regards

Americo

Americo Perez
Iron Contributor
Sep 22, 2018
I have test a.view in a custom list with a date column and it worked with [IDAG] filter.
So I am thinking that it has something to do with the way that the column is getting the date.
It is a flow that is feeding the dates to the column. Can be that ms flows has a different date format that the filter support?

Regards
Americo
- Frank Hessen
  Brass Contributor
  Sep 22, 2018
  I know that there is an ongoing issue with date formats, but I thinks it’s mainly related to norwegian format (dd.mm.yyyy).
  
  Estimated fix on that issue is in the coming week.