How to retrieve Yesterday's info using an expression in a text box?

[joshrussin]

Hey everyone, 

I am trying to get yesterday's data from my database and the text box stays empty. I can hard code the date and it works fine, but I need this to be automated and having some trouble using the Today()-1 function.

Sum({$<Date_Dash={(Date('Today() -1')},Program_Dash={'Mechanical Inspection'},Status_Dash={'Completed'}>} Processed_Dash)

I have also tried creating a variable in Main and using it in the 'Date(Today()-1)' place as well, no results.

Thanks!

[vishsaggi]

May be try this?

= Sum({$< Date_Dash = {"$(= Date(Today()-1, 'MM/DD/YYYY'))} , Program_Dash = {'Mechanical Inspection'}, Status_Dash = {'Completed'} >} Processed_Dash)

Assumed Date_Dash date format is MM/DD/YYYY.

[joshrussin]

Unfortunately, that gives me nothing too. I could either get a 0 answer or a blank return.

[vishsaggi]

Can you try adding = in the Date(Today ) like:

= Sum({$< Date_Dash = {" = $(= Date(Today()-1, 'MM/DD/YYYY'))} , Program_Dash = {'Mechanical Inspection'}, Status_Dash = {'Completed'} >} Processed_Dash)

Can you show me the format of your Date_Dash field?

[joshrussin]

Adding the = did nothing for me in the equation. Still returns nothing. thank you for trying to help me out!

[vishsaggi]

So what is that your are expecting can you share a sample to what you displayed in the table?

[joshrussin]

The end goal of this would be to have a text box for each of the following:

The first ones up top are just labels, output text boxes are separated a little.

(Lets say today is 6/2/2017, "WIP" is from yesterday)

Program_Dash               Completed               WIP

Loaners                          164                           122

[vishsaggi]

Try this? Sorry did not close the double quotes.

= Sum({$< Program_Dash = {'Mechanical Inspection'}, Status_Dash = {'Completed'},

                  Date_Dash = { " = $(= Date(Today()-1, 'M/D/YYYY'))" } >} Processed_Dash)

[joshrussin]

Now I am receiving a 0 instead of nothing.

[vishsaggi]

Time to share your app, it would be easy to work on can you upload your sample here?