Announcements
H,
In my App I have a Gallery, within the Gallery is two dates, created date and complete date (from SP list date and time columns). I want to have an icon in the gallery that is only visible if the completed date was equal to or less than 3 months.
Any help appreciated.
Thanks
@JimboSey
Set the visibility property of the button to DateDiff(ThisItem.DateCompleted,Today(),Months)<3
That works thank you. But I kinda need it work slightly differently. To explain...
The created date is when feedback has been sent, the date completed is when the feedback was completed, I want the icon to show when the created date and completed date is within three months as this is a service level agreement, so Id like the icon to show as a representation that we achieved this within 3 months.
Hope this helps.
!IsBlank(ThisItem.DateCompleted) && //There must be a completed date for the button to be visibleDateDiff(ThisItem.DateCompleted,Today(),Months)<3 &&DateDiff(ThisItem.DateCreated,Today(),Months)<3
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
