Help!! I have 2 comumns. 1 for Student name(...

expressions
(Abu Md. Moniruzjaman) #1

Help!!

I have 2 comumns. 1 for Student name(Name) & 1 for log in (DateTime). I hv a view named’Not loged in Today’. What will be expression for this view, so that it will get me the all the students who are not loged in today??

Urgent?

(Aleksi Alkio) #2

Do you have another table where you have all user names?

(Abu Md. Moniruzjaman) #3

Yes

(Aleksi Alkio) #4

DATE(MAX(SELECT(LoginTable[DateTime],[Name]=[_THISROW].[Name])))<>TODAY()

(Abu Md. Moniruzjaman) #5

Not working!! Error in expression ‘[_THISROW].[কর্মকর্তার নাম]’ : Unable to find column ‘_THISROW’

I used this expression in show _ if:

DATE(MAX(SELECT(বহিরাগমন রেজিস্টার [লগ ইন],[কর্মকর্তার নাম ]=[_THISROW].[কর্মকর্তার নাম])))<>TODAY()

:frowning: Translate

(Abu Md. Moniruzjaman) #6

@Aleksi_Alkio

help!!

Translate

(Aleksi Alkio) #7

Are you using this formula in Users table?