brandynsfetcu
05-09-2024Data Storage
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.