topic Compare 2 excel weeks column in the same table in App Development

Compare 2 excel weeks column in the same table

emyemyemy — Sat, 16 Nov 2024 17:18:55 GMT

I want to count rows where week1 column <= week2 column

This is what i tried but it shows 0 as a result !

LOAD id
from
[table.xlsx]
where

Date(MakeWeekDate(year(now()),Replace(week1,'S','')),'MM/yyyy')

< =

Date( MakeWeekDate(year(now()),Replace(week2,'S','')),'MM/yyyy' ) ;

and

I write count(id) in my Text object expression : IT shows me Zero while i have 2 rows matching with my where condition !

PS: Date( MakeWeekDate(year(now()),Replace(week2,'S','')),'MM/yyyy' ) : this expression is correct

Exemple : Week1 = S1 = 01/2021

I appreciate you help !

Re: Compare 2 excel weeks column in the same table

emyemyemy — Tue, 06 Apr 2021 09:43:39 GMT

I figured out the problem :

My second column (week2 ) name was divided on 3 parts separated like this [ date plannified installation ] i hv concatenated to be [ DatePlannified installation ] writed in 2 parts and it works .

Re: Compare 2 excel weeks column in the same table

emyemyemy — Tue, 06 Apr 2021 09:45:14 GMT

the code i write in my question is correct if any one need it 🙂