+07 on automation wth dates

[Markus_van_der_]

Hey guys, does anyone know why there is +07 at the end of this line?

also, for some reason, it’s not picking up the correct rows (i.e this test returns a row that has last modified on the 8th [it is now the 10th]) any ideas on how to be more specific with the date?

[Bill_Felix]

sure. it is a timezone helper for this date field. here is a quick screen of one of mine:

I imagine that if you end up having complicated logic running across several different date fields with different timezones denoted that this saves you several frustrating clicks. :confused:

[Markus_van_der_]

Hey Bill, thanks for the reply.

a follow-up, for some reason my automation does not want to pick up!

rrere|603x39 on the correct data.

If you have any ideas?

[Bill_Felix]

without knowing your particular situation exactly, one common problem that I run into myself is that the record ‘has already entered a view’ before… so it might be necessary to try out several different ‘test records’.

See if that helps? :man_shrugging: