DSA
December 31, 2021, 6:58pm
1
Hi,
I’d like to save a date and time in the database without using the date picker.
Tanks!
Hi DSA, I’m no expert, but intuitvely you could store the date as freeform text. This is assuming the user case is to capture a user’s input date?
The big downside is date formats are very specific, so this approach comes with a high risk of user error (which is why the date picker is more preferable in Adalo!)
I assume the other option would be to commission someone for a custom marketplace component (if this is important functionality)
Hope this helps!
Yongki
January 1, 2022, 9:37pm
3
Just in case, you didn’t see this thread,
v0.33
Calendar replacement as date picker when adding project.
[compressed 2021-12-09 at 2.12.01 PM (1)]
By default, add new project button will make start date for tomorrow and end date for next week, assuming most of community project cannot be started instantly, so tomorrow is the default selection and to get more quality result at least a week is recommended, so default selection for end date is a week from start date.
date without background = cannot be selected as they are before today …
I build my own date picker using list.
To know what date time field is calculated, read this post,
Just figured it out:
If you start calculating in a formula with a date/time you will get a decimal as a result:
[image].
This number represent the number of days since 01/01/1970.
That means today 6/18/2020 is 18431 days past 01/01/1970.
The decimal represent the fraction of time per day.
If you want to add 1 day you can just calculate
[image]
If you want to add minutes you have to use the fraction of 1/1440 for 1 minute
[image]
In the Custom Formula you can add minutes like this:
[im…