SharePoint Date Column Validation not showing error

%3CLINGO-SUB%20id%3D%22lingo-sub-1487657%22%20slang%3D%22en-US%22%3ESharePoint%20Date%20Column%20Validation%20not%20showing%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1487657%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20a%20date%20column%20in%20a%20list%20that%20I%20would%20like%20to%20have%20a%20validation%20on%20where%20users%20can't%20select%20a%20date%20within%20the%20next%20days%20of%20today.%26nbsp%3BI%20have%20got%20this%20formula%20to%20validate%20but%20there%20are%202%20issues.%20The%20column%20does%20accept%20only%20days.%3C%2FP%3E%3CP%3E%3D%7BDate%20Needed%5D%3CTODAY%3E%3COL%3E%3CLI%3EWhen%20a%20user%20puts%20a%20date%20within%20the%20next%207%20days%20it%20would%20save(expected)%20but%20it%20doesn%E2%80%99t%20show%20error%20even%20though%20I%20put%20an%20error%20message.%3C%2FLI%3E%3CLI%3EEven%20if%20the%20user%20selects%20a%20date%20that%20is%2030%20days%20from%20now%20it%20will%20still%20not%20save%20the%20file%20and%20no%20message%20too%3C%2FLI%3E%3C%2FOL%3E%3C%2FTODAY%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20to%20put%20the%20formula%20in%20the%20validation%20setting%20and%20inside%20the%20column%20setting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20also%20tried%20to%20see%20it's%20possible%20to%20edit%20using%20the%20PowerApp%20but%20the%20save%20data%20card%20doesn%E2%80%99t%20show%20in%20the%20app%20so%20I%20can%E2%80%99t%20but%20a%20rule%20in%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1487657%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Regular Visitor

Hi,

I have a date column in a list that I would like to have a validation on where users can't select a date within the next days of today. I have got this formula to validate but there are 2 issues. The column does accept only days.

={Date Needed]<TODAY()-7 

  1. When a user puts a date within the next 7 days it would save(expected) but it doesn’t show error even though I put an error message.
  2. Even if the user selects a date that is 30 days from now it will still not save the file and no message too

 

I have tried to put the formula in the validation setting and inside the column setting.

 

I have also tried to see it's possible to edit using the PowerApp but the save data card doesn’t show in the app so I can’t but a rule in

 

Any suggestions 

0 Replies