Hello. I am trying to compare a date from a list with todays date to see how many days apart they are. Ideally I would like to find the dates that are less than a week apart. Here is what I have but i get an error which looks like all the dates are being populated from the list into the end date.
the 6/13/2022 is just a test date. I could probably move the get todaysdate into that spot. I just can't get the duration to work properly. I would like it to create a notifier when it finds the date in the list.
Hi thank you that worked. it shows how many days till a certain date. I think in need to go the opposite way. I need to search the list and find the dates that will expire in 5 days from todays date. for example say the end date is set for 3/18/2022 and todays date is 3/13/2022. I want to be able to send a notify box saying 1 item will expire in 5 days. i assume the list? thing is where the change needs to be made? or is their and easier way? Here is what I modified so far