I have Zap running on a schedule every day at 6am.
The mechanism is to get yesterday's date in it and retrieve the record from the table that matches that date.
However, at 6:00 AM, it retrieves not yesterday's date, but the day before yesterday.
The Timezone in the profile has already been corrected to JST (Japan time).
I have a feeling that it probably has something to do with UTC, etc.
“Formatter by Zapier”, I wonder how to set it up to get yesterday's date based on JST.
Best answer by Troy Tessalone
Help link for inserting system generated timestamps: https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field
+14Help link for inserting system generated timestamps: https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field
You may also need to set the From Format.
Also, try changing the Expression to: -1 day
Thank you so much.
I changed the date from -1days to -1day.
But when I retest with the current time I get yesterday's date without any problem.
I will probably have to test in the morning Japan time to confirm that it worked, so I will report back tomorrow when I get confirmation.
+14Help link for inserting system generated timestamps: https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field
OK, I understand.
I changed setting Input.
now→{{zap_meta_human_now}}
So,I will try it.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
