Hi folks, thanks as usual for being so responsive. I followed @Victor 's great tutorial here [Adalo hints: how to create one single record for a one single date in a collection] for creating a record for a single day. I do the same thing he does, first using a button to set a temporar…

Hey @GOB . First of all: are you sure your Tester isn’t 1 day ahead in reality? San Francisco is 21 hours behind Wellington :wink: Second: in order to add / subtract days you should use +1 / -1. Dates&times are stored as number of days since 1/1/1970. You may get correct result when subtracting 0.5…

@Victor you are the Adalo Time Lord.

Thank you for the reply and excellent explanations as always @Victor ! The issue is the tester is 1 day ahead in reality often - but the recorded entry would be 2 days ahead, even when the displayed tmpCurrentDate was correct. Second: in order to add / subtract days you should use +1 / -1. Dates&t…

Hi @GOB , My pleasure. I didn’t provide the full solution though :-/ I’d say, if you are using dates only - I would try converting everything to number, storing it as number and operating with it as a number (I mean limiting the number of entries per day). And then convert numbers back to dates (yo…

Trouble with time

Get Help

Dilon December 12, 2023, 4:24am 2

@GOB, check this post made by @Victor! : Subtraction by one day - Date Bug - #6 by Victor

Topic		Replies	Views
Urgent help needed for creating record involving date/time Database	3	172	April 14, 2024
Subtraction by one day - Date Bug Database	9	808	January 21, 2025
Date calculations error Jobs / Freelance	5	399	February 7, 2023
Date calculation Get Help	3	521	December 11, 2022
Date&Time Error... does Adalo account for Daylight Savings? Get Help	3	1556	February 11, 2021

Trouble with time

Related topics