Insert current date automatically

[Kuroshi]

Currently, in my table I insert the date every day. It takes me only 10 seconds, but some days I forget to do it. I want to write a task to insert the date automatically, but I want to insert the DATE ONLY.  Again not the time...Just the date

[Barbie]

Hi Batchini,

You can achieve that by following the steps below.
1. Add a field in the table and set the Data Type to 'Formula'.
2. On the right pane of your Formula field, in the Options section, click Edit and paste this code: CAST([@field:Date] AS DATE). Please make sure to change the field name.
3. Create a Triggered action that will update the date with the formula field.
4. Create a Task that will automatically insert the current date on your table daily.

Please see attached file for reference.
 

 

 

I hope it helps.

Regards,
Barbie

[Barbie]

Just to add, you can refer to this articles on how to create a tasks and triggered actions: 

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

I hope this helps.

Regards, 
Barbie

[NailDyanC]

Hi, these video tutorials might also help you in building triggered actions :

 

 

 

 

[DefinitelyNot31337]

Hi @Barbie, running your Task at 12:00 AM of your selected TimeZone will remove the hh:mm:ss for you. If you don't mind the time at which your schedule runs, this might work for you.

 

[DefinitelyNot31337]

In addition, you may also just setup your Task in such way presented below so you won't need to specify a Trigger. *Pick your poison =D.

This workflow subtracts hour:minutes:seconds to whatever the value of Timestamp is so that it only retains the date part of the timestamp.

 

Hope this helps.

DN31337!

[trevans]

Quote

In addition, you may also just setup your Task in such way presented below so you won't need to specify a Trigger. *Pick your poison =D.

This workflow subtracts hour:minutes:seconds to whatever the value of Timestamp is so that it only retains the date part of the timestamp.

The solution above mostly works, but we ended up having to subtract milliseconds as well.