Forum Discussion

brandynsfetcu's avatar
brandynsfetcu
Data Storage
05-09-2024
Solved

Date and Time Functions

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:

  • 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. 

1 Reply

  • 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.