Pointage

[#1]

AutoNum	iEventNum	bDoorNumber	dEvent_Date	iUserNum
331635	7147	2	16/06/2014 08:15	150
331650	7159	2	16/06/2014 08:19	150
331661	7169	2	16/06/2014 08:21	150
334343	8166	2	16/06/2014 18:50	150

Commet sortir a partir du champ " dEvent_Date" comme  date d'entré  08:15 et  date de sortie 18:50

[maxgro]

in a text box?

=time(min(frac(Date#(dEvent_Date, 'DD/MM/YYYY hh:mm'))))

=time(max(frac(Date#(dEvent_Date, 'DD/MM/YYYY hh:mm'))))

[#3]

Dans le script .

[hic]

The conversion to time is straightforward:

     Time(Frac(Date#(dEvent_Date, 'DD/MM/YYYY hh:mm'))) as Time

But how do you know whether a timestamp is Entré or Sortie? If you say that anything before 12:00 is an Entré and anything after is a Sortie, then you can do the following:

     If( Frac(Date#(dEvent_Date, 'DD/MM/YYYY hh:mm'))<=0.5,

          Time(Frac(Date#(dEvent_Date, 'DD/MM/YYYY hh:mm'))) as Temp_dEntre,

     If( Frac(Date#(dEvent_Date, 'DD/MM/YYYY hh:mm'))>0.5,

          Time(Frac(Date#(dEvent_Date, 'DD/MM/YYYY hh:mm'))) as Temp_de_Sortie,

But I am not sure that that is a good criterion...

HIC

[#5]

la fonction min ne marche pas.

[hic]

Si tu utilises Min() dans le script, tu doit aussi utiliser un Groupe By, par example:

Load 

    iUserNum,

    Min (dEvent_Date)

    From ...

    Group By iUserNum;

HIC