Automatic expiration date.

[ChrisSayers]

Further to my previous post,. im setting up calibration table, I would like the calibration expiry day to be automatically calculated by a determine amount of months in the table.

 

I first thought that a easy formula would resolve the issue but can't seem to find any info on online help relating to dates apart from "datediff"

 

any help would be greatly accepted.

 

 

once i have figured this out,. i will be haveing the duration pulled from another database which will have the allocated months per item type. but will worry abou that another day.

 

 

PS please be aware i am currenlty using free version so some parts may not be avaialbel to eme 

[ChrisSayers]

sorry, i have figured this by using the date add function in formula

 

dateadd(Month, [@durationfield], [@Dateadded])

[GoodBoy]

Hello!

You might also want to browse this article if you want to include the expiration date in your search criteria: https://howto.caspio.com/faq/reports-datapages/how-to-filter-reports-based-on-an-expiration-date/

[astroboy]

Hello there!

 while browsing, I saw this forum post that is somehow similar to what you are trying to achieve:

 I hope you find this helpful!

[astroboy]

In addition to that, I also found another forum post regarding expiration date, but I believe this approach is utilizing custom code such as JavaScript:

In case you decide to upgrade your account in the future, I suggest trying Triggered Actions and Tasks for such workflow. They honestly make everything easier. Cheers!