Hi, I am new to Adalo, and I am pretty excited by its potential, but there is something that is driving me crazy
The user of the app will pick a date using the date picker (I will call it ‘initial date’).
I want to calculate a new date which is 6 months after the date picked by the user (I will call it ‘due date’), and then put the ‘due date’ in the database.
I know that I should be using a custom formula. but WHERE is Adalo can I do this?
Thank you so much for your help
Hi @shadynafie ,
Welcome to the community
These topics will help you!
Adalo calculates dates using UNIX timestamps which traditionally are the number of seconds since UNIX was implemented back in 1970. The only difference is that Adalo handles these in days, meaning that if a typical UNIX timestamp is 1634310307 (number of seconds), the day equivalent in Adalo is basically just a moved decimal point: 16343.10307.
Knowing this you can create records in a collection called “Duration” that have the duration in this format and then add the selected duration from a dr…
I need help setting a due date with specific time.
When someone checks something out from my library, a due date is set and added to the LibraryRecords collection. Borrowed items must be returned by 6 PM on the due date.
My problem is how to identify when something is late.
First, I tried using a simple date field for the due date. Then I created a list showing anything with a due date before start of today.
But I discovered that, when you just use a date field, it always returns date withou…
Check this : Add Months in JS.mp4 - Google Drive
JS var date = new Date('date_input');
var date = date.setMonth(date.getMonth() + months_input);
var after_date = new Date(date);
var formatted = (after_date.getMonth()+1)+'-' + after_date.getDate() + '-'+after_date.getFullYear();
return formatted;
( In here replace the inputs with date_input text and months_input text! )
The Component Details Instructions to download components from Pragmaflow website : <a href="htt…
Thank you
system
Closed
October 6, 2022, 5:28am
3
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.