About date and time appearance.

[#1]

Hello;

I added qv screen  pictures,

I just want the yellow painted dates to be visible;

Please help.

Thank You.

[marcelviegas]

Do you need the time, too?

[marcelviegas]

modifica em seu script:

load

[ADI SOYADI],

[user name],

TarIh,

Baslangic,

min(Login) as Login

from table

group by [ADI SOYADI],[user name],TarIh,Baslangic;

[#4]

Try this..

aggr(date(Min(Login),'DD.MM.YYYY hh:mm:ss'),[ADI SOYADI],[user name],TarIh,Baslangic)

[avinashelite]

Could you please explain the requirements ?? you need to display only certain dates and hide the rest ? if so that the condition for displaying and hiding the date

[#6]

Hello;

I Use;

ODBC CONNECT32 TO [MS Access Database;DBQ=C:\Users\07008557\Desktop\LoginLogout\Data\LoginLogout.accdb];

LOAD "Agent Name",

    "Login ID" ,

    Extn,

    min("Login Time")as Login,

    "Logout Time",

    "Logout Reason",

Date("Login Time",'D.M.YYYY') as Tarih,

    ApplyMap('Map', "Login ID",'Diğer') as "ADI SOYADI",

ApplyMap('Map1', "Login ID",'Diğer') as Baslangıc,

ApplyMap('Map1', "Login ID",'Diğer') as Bitis;

SQL SELECT *

FROM "C:\Users\07008557\Desktop\LoginLogout\Data\LoginLogout.accdb".Login

group by [ADI SOYADI],"Login ID",Tarih,Baslangıc;

But was no solution.

I need yellows line.

[#7]

Are u tried this in front end

Try this..

aggr(date(Min(Login),'DD.MM.YYYY hh:mm:ss'),[ADI SOYADI],[user name],TarIh,Baslangic)

[Anil_Babu_Samineni]

Try this?

ODBC CONNECT32 TO [MS Access Database;DBQ=C:\Users\07008557\Desktop\LoginLogout\Data\LoginLogout.accdb];

Map:

Mapping Load....;

LOAD "Agent Name",

    "Login ID" ,

    Extn,

    min("Login Time")as Login,

    "Logout Time",

    "Logout Reason",

Date("Login Time",'D.M.YYYY') as Tarih,

    ApplyMap('Map', "Login ID",'Diğer') as "ADI SOYADI",

ApplyMap('Map1', "Login ID",'Diğer') as Baslangıc,

ApplyMap('Map1', "Login ID",'Diğer') as Bitis group by [ADI SOYADI],"Login ID",Tarih,Baslangıc;

SQL SELECT *

FROM "C:\Users\07008557\Desktop\LoginLogout\Data\LoginLogout.accdb".Login

;

[#9]

I tried your suggestions but it did not succeed. I added the file as an attachment to the first message. Can you check.

[marcelviegas]

rank(LoginT,Tarihl)