Jump to content

Search the Community

Showing results for tags 'nesting'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Caspio Bridge
    • Caspio Apps for Ukraine
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






Found 1 result

  1. I need to be able to calculate a date, created by a formula, which is prior to whatever the current date is. That sounds easy but I cannot figure out how to do it in my specific situation. Because I needed to determine a date that was 2 weeks after a date entered based on two different scenarios I created this formula in my data table: CASE WHEN [@field:Brand_Received] = 'Brand 1' THEN Dateadd(day, 14, [@field:Date_1]) WHEN [@field:Brand_Received] = 'Brand 2' THEN Dateadd(day, 14, [@field:Date_2]) END It works well to give me the date that is two weeks after the specific date given, based on unique requirements. However, now I need to create a field that checks to see if the new Formula Date is before whatever the current date is. I have not been able to get a result for this. Caspio does not allow me to use results from one formula field as variable in another formula field. And I have not been able to figure out just yet how to combine all the variables I need to produce a valid formula. Any thoughts?
  • Create New...