Answered

Filter GetItems Dates stored in a Text column

(0) Share

Report

Posted on by lalford09

163

I have a column in an SP list that is set to text, but holds date values, and I need to filter that column to get any items from the last week, however it is returning all sorts of items instead. Are there anyways to do this as my current option doesnt seem to work. Below is my current Filters:

I am setting a variable to get the date 1 week ago:

addDays(utcNow(),-7,'yyyy-MM-dd')

I then filter on the GetItems:

PageStatus eq 'Fully Approved' and FinanceApproverApprovedDate ge@{variables('var_DateFilter')} ' and field_1 eq 'TEST'

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @lalford09

Pls try the below filter query:

PageStatus eq 'Fully Approved' and FinanceApproverApprovedDate ge @'{variables('var_DateFilter')}' and field_1 eq 'TEST'

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
lalford09 163 on at

Like (0)

Report
Copy link

Link copied!

Hi @ManishSolanki

Works perfectly, thank you! Although it looks identical to mine, whats the difference?

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!
Here is the list of differences in the filter query syntax:

1. There was no blank space between ge and variable.

2. The variable was not wrapped inside single quotes.

3. There was extra blank space before the end single quote in the variable expression.

I have highlighted the diffrecensc in red color:

PageStatus eq 'Fully Approved' and FinanceApproverApprovedDate ge@{variables('var_DateFilter')} ' and field_1 eq 'TEST'

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No