Formula fields in Structure

[Mikael Sandberg]

Hi Community,

In Structure, can you create a formula field that outputs the the diff between two date/time fields in minutes?

[Kelly Arrey · Accepted solution]

Hi @Mikael Sandberg I'm pretty sure that's possible. Here's the Structure Cloud Sample Formulas page.

Here's a sample formula for "days past due": 

IF dueDate < NOW():
   DAYS_BETWEEN(dueDate, NOW()) CONCAT " days late"

Here's a link to the Structure Formula Duration Functions page.

[David Niro]

@Mikael Sandberg ,

@Kelly Arrey is right, it is possible using a formula column.  The function you will want is HOURS_BETWEEN().  You can multiply by 60 to get the minutes.

something like:

HOURS_BETWEEN(datetime1,datetime2) * 60

Best,
David 

[Mikael Sandberg]

Awesome, thank you both!