Forum Discussion
Analyst_NK
Feb 01, 2022Copper Contributor
SharePoint Rule for Date Field
I have been looking for an answer to this but haven't been able to find any. I'm hoping this group can help. I have a field called "Desired Start Date." I am trying to set up a rule that warns the us...
DhirenMehtaMSFT
Microsoft
Feb 01, 2022Are you trying to use Conditional Formatting to show a warning message? If so, may be this might help.
https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#formatting-items-based-on-arbitrary-dates-advanced
If not, can you please provide more details on what steps are you taking and what use case are you trying to implement? (i.e. When user is creating an item ?) . Also, are you using Infopath form and trying to set up a rule within Infopath form or are you using Power Apps form?
https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#formatting-items-based-on-arbitrary-dates-advanced
If not, can you please provide more details on what steps are you taking and what use case are you trying to implement? (i.e. When user is creating an item ?) . Also, are you using Infopath form and trying to set up a rule within Infopath form or are you using Power Apps form?
Analyst_NK
Feb 01, 2022Copper Contributor
DhirenMehtaMSFT I'm trying to have SharePoint show this warning when the user creates an item that is
less than 7 days in the future. I thought I could do something similar to the image attached. The problem
seems to be that it displays on every date, not just those dates that would fall between the date and 7 days from now.