Todays date in a formula field

[hmorrow407]

How do I get todays date in a formula field. Date() is not allowed in formula fields.

[Kurumi]

Hi @hmorrow407 - Getting todays date is not applicable to Formula Fields. However, you can use this in Calculated Fields or Calculated Values. For reference, you may check this post:

[hmorrow407]

I have already seen those pages. They are of no help. I need today's date in a formula. Is it possible that Caspio is that deficient!

[CoopperBackpack]

Hello @hmorrow407,

As you can read in this article https://howto.caspio.com/tables-and-views/data-types/formula-fields/ The formula is not valid when it contains non-deterministic functions (GetUTCDate, Rand), etc.  

As a workaround, you may use Tasks or Triggered Actions to implement logic that involves today`s date. 

For example, you need to store in the table how many days have passed since the purchase. 

This can be achieved by Task that runs daily and updates the table

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

https://howto.caspio.com/tables-and-views/triggered-actions/

If you like, please provide an example you need to achieve, so we can suggest.

Hope this helps.

[GoodBoy]

Hello! This post may help as well