Problem with Dates

[vassil-dimitrov]

Hello ,
I have a strange problem with dates. When I take a date from DatePicker in Front end page it shows date as Thu May 21 2020 00:00:00 GMT+0300 (Eastern European Summer Time)

Then When I transfer the same variable to backend function and print into console same variable it shows : 2020-05-20T21:00:00.000Z
Can someone help me how to make them equal ?

Best Regards,

Vasil

[GraceGrabillo]

No fix from Wix? I am having the same problem. I don’t know where to parse since the date format showing on the console is the thing that I want, but on the backend data its different and shows a yellow mark telling its invalid format.

[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.

[GraceGrabillo]

Thanks @CODE-NINJA I’ll check moment.js and will update if it works or not.

[GraceGrabillo]

Ok, so browsing the documentation, I was presupposed that moment.js is the thing I need.
In my code, I converted the value on the datepicker element:

let selecteddate = $w('#targetschedule').value;
        let savethedate= moment(selecteddate, true).format("MMM DD, YYYY");

On the console, it gives the correct format:

I have this insert code:

let toInsert = {
            "title": $w('#projecttitle').value,
            "targetDate:": savethedate, ... etc

But when looking at the collection, the yellow icon is still there!

I feel like I’m missing something.
I have to go this way because there are values to insert on my content that comes from a selected dynamic page.

[CODE-NINJA]

Which format does expect the collection ?

Take a look onto the following picture…

DO YOU RECOGNIZE SOMETHING SIMILAR, REGARDING YOUR ISSUE ?

Maybe this is also interesting for you…

Visual Learner - coding a repeater

@jfriede As promised —> here it is! —> https://www.media-junkie.com/datepicker [image] This is your interactive-example-slot. Your database… [image] How to use this "interactive-example? You can use the predefined DATABASE → “SportSheduler” You can see, which fields are already activated and ready to use. Setup one of the 4 given DB-Presets/Slots to get your DATABASE connected. Example… [image] You will have to change the PRESET/SLOT for —> “SportSheduler” 4) General-Settings: …

[GraceGrabillo]

Thank you @CODE-NINJA I’m reading it and somehow its similar in a way he puts the input values on his collection.

I was assuming that since it’s Wix’s datepicker element, it should automatically be the date format on the CMS collection when the data type “Date” is used. Coding it on the front-end to save the datepicker selected value to the CMS should not be the issue.

I’ll get back to you after reading your link and will try to do some tricks and I hope it works.