# How to hard code a default datetime value during a database update?

**URL:** <https://forum.adalo.com/t/how-to-hard-code-a-default-datetime-value-during-a-database-update/34246>\
**Category:** Get Help\
**Created:** [December 4, 2022, 8:35pm UTC](https://forum.adalo.com/t/how-to-hard-code-a-default-datetime-value-during-a-database-update/34246 "2022-12-04T20:35:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![slothmike](https://avatars.discourse-cdn.com/v4/letter/s/a88e57/32.png) [@slothmike](https://forum.adalo.com/u/slothmike)\
**Post date:** [December 4, 2022, 8:35pm UTC](https://forum.adalo.com/t/how-to-hard-code-a-default-datetime-value-during-a-database-update/34246/1 "2022-12-04T20:35:19Z")

</div>

Hi,

I have a database for users that I’m using which has some properties for a date range filter I set on another screen. This particular app is for an event that has a predefined date range and a bunch of sessions within the event. Each time a user is created and selects their sessions, I want to set a default “start date” so my calendar widget starts on day 1 when they open the agenda. What I can’t figure out is how to enter the date in the date & time properties I have set up. I’ve tried unix time but that doesn’t seem to work. Is there a way I could just enter in February 27th 2023 into that field? I feel like I’m overlooking something simple here.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/8/0/80b482f3b0c37f5c23e925c3213f5c5c4e675fea.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/0/4/041f43963487ad625129ced83442c3f97ea6bf5e.png)

---

<div class="post-metadata">

**Author:** ![Yongki](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yongki](https://forum.adalo.com/u/Yongki)\
**Post date:** [December 5, 2022, 8:45pm UTC](https://forum.adalo.com/t/how-to-hard-code-a-default-datetime-value-during-a-database-update/34246/2 "2022-12-05T20:45:03Z")

</div>

Hi @slothmike ,

You can check this cloneable app to see the database collection.

[Wordalo Copy (adalo.com)](https://previewer.adalo.com/b1037515-2d32-4c63-b017-72602c9bacb3?_gl=1*yqtt4v*_ga*MjYyNDczNDE3LjE2NjkxNTU2MTE.*_ga_SWT45DV35L*MTY3MDI3MjczMi41My4xLjE2NzAyNzI5NzAuNTQuMC4w)

 ![Screen Shot 2022-12-06 at 3.42.29 AM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/6/1/615852952f6ad22ee11355325effc59e7b39c167.png)

For example, if you put 19400 at that field, it is recognized as Feb 12, 2023.  
Increase by 1 to get for the next day.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [December 15, 2022, 8:45pm UTC](https://forum.adalo.com/t/how-to-hard-code-a-default-datetime-value-during-a-database-update/34246/3 "2022-12-15T20:45:23Z")

</div>

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.