Odata Filter documents of sharepoint library with formatDateTime doesn't work

[MD2409_]

Hi Community,

getting crazy with this stupid date time format expression filter.

In test environment we have a german sitecollection / library / date coulmn

There the filter which workfs fine with:

The coulmn show the date eg 30.6.2020
Next_x0020_Review_x0020_Due_x0020_By eq 'formatDateTime(addDays(utcnow(),-7),'yyyy-MM-dd')'

In Prod there is a english sitecollection and the same filter doesn't work

The coulmn show the date eg 2020/06/30

How is the correct expression for the english library / column ?

Best regards

[DeepakS]

HI @MD2409_ 

Have you tried following expression in prod:

Next_x0020_Review_x0020_Due_x0020_By eq 'formatDateTime(addDays(utcnow(),-7),'yyyy/MM/dd')'

Regards,

[ChristianAbata]

hi @MD2409_  you can try @DeepakS  sols the format is  7/13/2017 or you can change the column format.

https://sharepointmaven.com/change-date-format-sharepoint/

[v-bacao-msft · Accepted solution]

Hi @MD2409_ ,

Please try to run Get items action without configuring Filter Query first and check the Body of the action.

Get the display name of the specified date column and check the format of the date.

Then you could configure Filter Query again and format the date parameter to filter items.

Best Regards,