How to retrieve only the data sent yesterday in a table

Hi @Murinhardt 

Zap Action: Zapier Tables - Find Records (Output as Line Items)

If you log the Date in a field, then you can search by yesterday’s date.

Hi @Troy Tessalone 

Thank you for reply.

Already has an item with a send date.
I don't know how to specify “yesterday” in Find Records (Output as Line Items).

@Troy Tessalone 

Yes.

I set this in the table.(submit_datetime)

Are you talking about yesterday and here that you have a choice?

I can't find it.

@Murinhardt 

Like this...

@Troy Tessalone 

Oh..Ok.

So, Can you show me the table side settings for this item?

@Murinhardt 

Try using the Date field you already have in the Zapier Table.

When in doubt, test it out.

@Troy Tessalone 

I tested it many times.
But it seems to recognize “yesterday” as a string, even though I set it up the same way you did

@Murinhardt 

Did you try this suggestion?

Otherwise, use this Zap action: Formatter > Date & Time > Format

Insert system timestamps: https://help.zapier.com/hc/en-us/articles/8496275717261#iso-8601-timestamps-0-1

@Troy Tessalone 

Yes.I tried this.

Sorry,But I didn't understand why I needed to do this, since I already have the date in the table with the DateTime type.

@Murinhardt 

The value for yesterday changes each day.

Use a system generated timestamp in a Formatter step to get yesterday’s date in the same format as you have configured in your Zapier Table.

Then map the output variable from the Formatter step to be the Zapier Tables Zap action Lookup Value.

@Troy Tessalone 

Thank you! I see.
I understand now that Zapier does not automatically determine yesterday.

I will try it again.