https://forums.caspio.com/topic/8867-insert-current-date-automatically/?do=findComment&comment=28142

I implemented the above solution in order to insert just the date for a particular column. However, upon creating a task that included a date comparison on that column, we found that matches were not being made correctly because we didn't remove milliseconds as well. This took some trial and error since the datasheet was only showing the date part of the timestamp, even though milliseconds were not 000.