Glad that’s working now @Magpie2000k! Hope you don’t mind but I’ve moved your new question out into it’s own topic since it’s different to the one being discussed previously.
It’s possible to use date/time modifiers like +1d to add a day to a selected date in a date/time field.
For example this set up:
Would result in the date being added as 2023-04-21 in Monday.com. And as the field from Google Sheets that contains the date is select that will meant that whatever date is present in the row that triggers the Google Sheet will have 1 day added to it automatically by the Zap.
Just make sure to leave a space between the selected date and the date modifier ( +1d). You can find out more about working with date/time modifiers here: Adjust date and time values in Zaps
Hope that helps!
That is great but Date - 1 month doesnt seem to work
Looking at the link now to see if can sort but if you see this please let me know
Thankyou so much
Hi @Magpie2000k
Jumping in to see if I can help!
Did you mean -1month or -1d?
Thank you all I have sorted it with all your help out there.
I have now mastered what to me was a fairly complex Zap. Lets see how much more fun I can have and time I can save the whole team… Should have used this on so may projects over the last few years.
Legends all of you..
Hi @Magpie2000k
You’re welcome! We appreciate that!
There seems to be a issue with the zap I created.
If anyone changes a single date in Mnday.com All of the dates immediately change in all groups.
they just become date.1 day irrespective of the fact that they were set as date plus 2 weeks or 6 weeks etc.
Anyone have any siggestions
Hi @Magpie2000k,
I’m so sorry for the troubles with the Zap.
Just to make sure we're on the same page, is the issue you're encountering related to the same Zap discussed in this post? If so, it would be super helpful if you could provide some context and perhaps share some screenshots of your entire Zap setup. This will allow us to better understand what might be going wrong.
We're particularly interested in seeing the "Action" section of your action steps, which includes all of its fields. Here's an example of what we're looking for:
(view larger)
Please don't include personal information in the screenshot, or be sure blur out any personal information.
Thanks!