Jump to content
  • 0

Excel Formula converted to Caspio


Question

Hello all, I have a current Excel Spreadsheet and new to Caspio I am creating a formula in my data sheet, however the existing Excel one I copy over is not functioning. Let me explain here:

The current Excel Formula is: =ROUND(((DAYS360(J7;$P$2))/360);1) where J7 is a date of birth, $P$2 is the current date (today) and the answer should read the person's age example 59,2.

How would I convert this to Caspio?

Regards, Mark (Johannesburg, South Africa)

Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

If it's inside the Table, you can't do it since you can't put dynamic content inside an Database Tables for many reasons.


If you just want it displayed, you can use Calculated Field in a Reports DataPage. This will not be stored in the table.

Ref:https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/

 

If you want it stored in the table, you can use an Application Task that runs everyday to recalculate the age

image.thumb.png.f9cbbb2e10aa5beee5f4646a81996f65.png

image.png.67f0108a150460c55e59a28f0532c354.png

Ref: https://howto.caspio.com/tasks/

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...