if match : Confirm function :

[ab92]

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.

[YoussefBelloum]

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 ?

[gerry_hdm]

benutz du eine chartbox zum anzeigen ?

[Anonymous · Accepted solution]

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

[ab92]

Sorry but I don't speak German ...

[gerry_hdm]

Apology for the German answer
I wasn't paying attention.

greeting Gerold

[ab92]

No problem

Best,

A