Are there date-based variables for minutes and seconds? | Community
Skip to main content
Level 2
February 13, 2020
Question

Are there date-based variables for minutes and seconds?

  • February 13, 2020
  • 0 replies
  • 307 views
I'm wondering if there are any date-based variables for minutes and seconds? I know q=quarter, h=hour, d=day, etc, but I can't anything similar for minutes or seconds . . . My underlying goal is to create a custom field (iitDevStatusStart2) to capture the time an issue goes into development status (IND) for the second time (and not capture any data at the same time as when the first time is captured in iitDevStatusStart1). I've tried various other ideas that seemed simpler but didn't work; this is the closest I've come to success (see the equation below), however I need to change the 2h (2 hours) to be 2 seconds. I would take 2 minutes in a pinch. I tried to simply divide 1h by 1800 ($$Now-(1h/1800)) or put in a decimal part-hour ($$NOW-.000555555h), but these ideas didn't seem to work. Here is a part of my desired equation in plain language: If the time that this issue went into IND status the first time is very recent (less than 2 seconds ago), leave this second field null. Otherwise record $$NOW in the second field. IF(Status='IND',IF(iitDevStatusStart1>$$NOW- 2h ,null,$$NOW)) Nathan Roberts
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.