Find a date from a list of dates

[Glidy]

How do I find the date from a list of dates.

I tried to create by if then else and there seems to be no option to do this search.

I needed to find the specific day, for example 11/03/2022 from this lookup list

Thanks in advance

[Darren_Murphy]

It depends. Here are two methods.

• First method. ONLY use this method if the Date you are looking up has been sourced from the same list of dates. If it hasn’t, this method almost certainly won’t work.
  – Create a relation that matches the date you want to find with the column that contains the list of dates.
  – Use a lookup column to fetch whatever you need through the relation

• Second method. Use this if the Date you are looking for has not been sourced from the same list of dates. ie. maybe it’s user entered
  – Convert all your dates to numbers using the following math formula:

Year(Date) * 10000
+ Month(Date) * 100
+ Day(Date)

– do the same as above with the date you’re wanting to find
– now proceed as per the steps in the first method (relation + lookup)

[Glidy]

Thanks Darren, I’ll try what you told me

[Glidy]

Thank you very much @Darren_Murphy , it worked here

I just couldn’t do it using the lookup, so I used the Array Contains Element

And he marked for me the dates that matched on the list

Thank you so much again, thanks and see you later