Hey, Everyone - I have a training app that I ...

expressions
(Jayne Hawkins) #1

Hey, Everyone - I have a training app that I use to register people for courses. The list of courses is a dropdown enum that pulls its information from a list of courses in the spreadsheet. It’s currently set up like this:

SELECT(Courses[Course2], [Public|Private] = “public”)

This shows me the public courses (which I want) but I also need to show current courses ONLY (ie. today’s date or later).

What would I add to this expression to show only courses that are current AND public? I’ve used today’s date -1 to show current courses in other areas of the app, I’m just not sure how to apply it to this expression. Thanks!

(Jayne Hawkins) #2

Sorry, it’s [Date]>today()-1 that I’m using elsewhere.

(Reza Raoofi) #3

Assuming your Courses table has a [Date] column, something like this should work:

SELECT(Courses[Course2],

AND([Public|Private] = “public”, [Date]>today()-1))

(Jayne Hawkins) #4

@RezaRaoofi YESSSSSSSS! I had ‘AND’ in the wrong place. Thank you! I’ve spent way too much time trying to figure that out.

(Reza Raoofi) #5

You’re welcome @Jayne_Hawkins