topic Re: if match : Confirm function : in App Development

if match : Confirm function :

ab92 — Wed, 14 Mar 2018 09:30:32 GMT

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!

YoussefBelloum — Wed, 14 Mar 2018 09:35:43 GMT

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 — Wed, 14 Mar 2018 09:38:14 GMT

benutz du eine chartbox zum anzeigen ?

Anonymous — Wed, 14 Mar 2018 09:49:23 GMT

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 — Wed, 14 Mar 2018 09:55:47 GMT

Sorry but I don't speak German ...

gerry_hdm — Wed, 14 Mar 2018 09:59:24 GMT

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

greeting Gerold

ab92 — Wed, 14 Mar 2018 13:48:58 GMT

No problem

Best,