Create a list view filtered by a date column?

[Americo Perez]

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 but when I select the column contining the date in the create view tool and I set the 2018-09-01 as date the view is empty.

If I use [TODAY]-20 Sharepoint says that is not a valid date format. 

Another I noted is that when I use 2018-09-01 Sharepoint change the format to 2018-9-1, strange.

How can I use the date to filter the view.

Best regards

Americo Perez

[#2]

Hi, @Americo Perez

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

[#3]

Thanks,

but it still saying that the date format is not supported

Regards

Americo

[#4]

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

[#5]

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.