Sep 21 2018 06:07 AM
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
Sep 22 2018 08:17 AM
Hi, @Americo Perez
If the regional settings are set to swedish you have to use [IDAG] instead of [TODAY]
Sep 22 2018 08:30 AM
Thanks,
but it still saying that the date format is not supported
Regards
Americo
Sep 22 2018 03:19 PM
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
Sep 22 2018 11:56 PM