cancel
Showing results for 
Search instead for 
Did you mean: 

Date and Time Functions

brandynsfetcu
7 - Data Storage
7 - Data Storage

Hello, is it possible to add the Add features to sisense cloud-hosted environment Formula Editor? We don't have any of these functions available inside of the Formula Editor.

  • ADDYEARS(datetime, number)
  • ADDQUARTERS(datetime, number)
  • ADDMONTHS(datetime, number)
  • ADDDAYS(datetime, number)
  • ADDHOURS(datetime, number)
  • ADDMINUTES(datetime, number)
  • ADDSECONDS(datetime, number)

Sisense Documentation:

1 REPLY 1

DRay
Community Team Member
Community Team Member

Hello @brandynsfetcu,

Thank you for reaching out. I would like to make sure I understand what you are asking for here. Those formulas are for custom tables/columns in a data model, and you would like them added to the Widget Formulas also, is that correct? 

Our widget formulas have to output a number, so those date manipulation functions are currently data side only. 

David Raynor (DRay)