Forum Discussion

Americo Perez's avatar
Americo Perez
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 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

admin
developer
Lists
SharePoint Online

4 Replies

    • Americo Perez's avatar
      Americo Perez
      Iron Contributor
      Sep 22, 2018

      Thanks,

       

      but it still saying that the date format is not supported

       

      Regards

      Americo

      • Americo Perez's avatar
        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

         

Resources