Solved: I want to add expression till today in slice

Lovkesh_Aggarwa · 08-18-2021 01:52 AM

Dear Admin, Kindly suggest me what expression will apply if i want task show till today or till mention date?

Aurelien

AND(
  [TASK REMINDER DATE]<=TODAY(),
  OR(
    [STATUS]="Not started",
    [STATUS]="Started"
  )
)

For reference:

View solution in original post

Aurelien

Hi @Lovkesh_Aggarwal

There is no admin but a community, to help each other

I suggest you have a look in the section “Examples that Compare Dates, Times, and DateTimes” in that article:

Furthermore, I suggest you also have a look here, there are good suggestions:

pravse

Assuming there is a DueDate column in the tasks table,

[DueDate] < TODAY()

Lovkesh_Aggarwa

Thanks sir it solve my problem but i want know how to add two expression? sorry for that i am new in expression but once i know basic then i can do it all myself

Aurelien

Hi @Lovkesh_Aggarwal

AND(
  [TASK REMINDER DATE]<=TODAY(),
  OR(
    [STATUS]="Not started",
    [STATUS]="Started"
  )
)

For reference:

Kirk_Masden

@Aurelien is correct in pointing out that inquiries are normally addressed to the whole community and that we help each other. Nonetheless, your inquiry got an answer from Praveen, the CEO of AppSheet:

So, though Aurelien’s comment is technically correct, this time you really did succeed in getting a response from the top!