Skip to main content

+07 on automation wth dates

  • December 10, 2020
  • 3 replies
  • 32 views

Forum|alt.badge.img+2

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?

3 replies

Bill_Felix
Forum|alt.badge.img+9
  • Inspiring
  • December 10, 2020

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:


Forum|alt.badge.img+2
  • Author
  • New Participant
  • December 14, 2020

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:


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
Forum|alt.badge.img+9
  • Inspiring
  • December 14, 2020

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: