I am trying to schedule an email of data posted of last 7 days.
Trying to filter based on InqDate Field (which is a datetime field) in share point - But it getting failed,
Below is the error show and also screen shot main screen
below is share point column which I am reffering:
Please advise correct way to write the requirement.
Dear Mr. Marco,
Thank you for your advise.
As advised I applied as below, still the error ,
Below is the screen shot of error as well my applied method
Please advise what correction to be done.
Please note First I typed InqDate gt'
Then clicked on Formula button and type addDays(utcNow(),-7,'dd-MM-yyyy')
then after return added at the end '
I hope I have not made mistake, but confused if all the complete line to be written on formula bar, but the return is ok 17-0-2022
Hello @MIA27 ,
you should put the expression in the "expression" bar:
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492