Date and Time Functions

[brandynsfetcu]

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:

• https://docs.sisense.com/main/SisenseLinux/date-and-time-functions.htm

[DRay · Accepted solution]

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.