I've got a line item where I import date from AWS everyday. I also have a list called Split Week where I have two 'Date' formatted properties called Start of Week and End of week.
Is there any way I can check if the Date of import lies within the 2 properties?
Thanks in advance.
Go to Solution.
you can use the standard comparison operators > < >= <= between Date formats or Period formats
You can do a comparison by using operators >,<,<=, >=,<> etc.. between dates.
Add a new property in the list and put the comparison formula as shown below.
Hope this would be helpful!!