Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can someone please tell me if it's possible to use Match function in my request?
In my application I've two differents date: entry and exit
I created a special calendar in order to know the numbers of présents, I find the solution by intervalmatch..
Now, I would like to calculate the numbers of peole entry and exit :
I've no idea to translate this condition in my table...
I tried the condition but is not working.
Maybe I need to use the if match but any one can help me.
if(Entry_date = Present_date,1,0) as Flag_Enty
Thanks!
A.
Maybe :
if ( Match ( Entry_date , concat ( Present_date , ',' ) ,1,0) as Flag_Enty
Have not tested it so may have a typo and may need a dollar expansion around the concat like this :
if ( Match ( Entry_date , $(concat ( Present_date , ',' )) ,1,0) as Flag_Enty
Hi,
if(Entry_date = Present_date,1,0) as Flag_Enty
the syntax looks good
can you take a screen shot from your script (where you have this Flag field) and another one from your table sctructure ?
benutz du eine chartbox zum anzeigen ?
Maybe :
if ( Match ( Entry_date , concat ( Present_date , ',' ) ,1,0) as Flag_Enty
Have not tested it so may have a typo and may need a dollar expansion around the concat like this :
if ( Match ( Entry_date , $(concat ( Present_date , ',' )) ,1,0) as Flag_Enty
Sorry but I don't speak German ...
Apology for the German answer
I wasn't paying attention.
greeting Gerold
No problem
Best,
A