Problem with Dates

[CODE-NINJA]

There are different time-formats you can use.
In general, when working with times → you probably should work with → TIMESTAMPS ← do the calculation and convert it to the time-format of your choice after calculation.

Also you maybe want first to check what kind of format is setted up inside of your database. As long as you did not setted-up the format of a DB-Field it will get the yellow WARNING-SIGN inside of your DB.

Also read the following post …

How to query a date field and show with a lamp if it isn´t empty?

Instead of using —> nicknames —> maybe you can use the → OWNER-ID → " _owner " All you need are two dates, right? → STARTING-DATE and EXPIRE-DATE to be able to calculate between these 2 dates. You also can break down date and time to a unique unit called → TIMESTAMP <— and with these timestamps you can calculate very easy. You can use some online time-converter, like… Epoch Converter - Unix Timestamp Converter You can install → MOMENT.JS in your project, to work more easy with dates and t…

…or this one…

Code for the time difference in hours in a time picker

I will keep your post in mind. Will answer tomorrow. …to be continued…

…or this one…

How to add an hour (or more) to timepicker value?

Hi everyone, is there a way to change the value of a timepicker to any number of hours, minutes and Seconds to add? Here’s an example: Someone decides to attend an event. The event starts at 8 am and lasts approximately 1.5 hours. I would now like to display the time by which you are finished. Does anyone have any ideas about this? I tried to add an addhour element to the timepicker, but it didn’t work. I had imagined the following: Date newDate = DateUtils.addHours(oldDate, 3);

…and this one…

convert timestamp to normal date

No problem and like always → do not forget to like it, if you really liked it

Convert your date to the right format, which is expected by your DATABASE.