About Tjfyuuii

Tjfyuuii

Hi,In my table called "Vehicles" I created a virtual column which should allow me to know if today's date is present in a list of dates. My formula is as follows:IF(IN(TODAY(),(SELECT(Pret[V_PRET_LISTJOURS],[Pret_VehicleId]=[_THISROW].[Vehicle_Id])))...

Tjfyuuii

I had to abandon my virtual column to replace it with an enumlist type column.Rather than reformatting my day list I reformatted Today() as follows:IF(IN(TEXT(TODAY(),"dd/mm/yyyy"),SPLIT(TEXT(SELECT(Ready[Ready_ListDay],[Ready_VehicleId]=[_THISROW].[...

Tjfyuuii

Hi,Indeed it seems that date formats bore me. I tried to reformat the date in the formula without success.

Tjfyuuii

List with Dates  

My Stats

Tjfyuuii's Bio

Badges Tjfyuuii Earned

Recent Activity

Compare a list of date with today

Re: Compare a list of date with today

Re: Compare a list of date with today

Re: Compare a list of date with today