Import date range CSV not recognised

[David.T]

Hello,

I have a CSV file I would like to import with date-range inside.
[‘Jan 10, 2020 01:00 am’; ‘Feb 10, 2020 01:00 pm’]

When I import it by the database uploader, I don’t have any error but the dates are not recognised. In my database it registered : [“Jan 1, 1970 1:00 am”,“Jan 1, 1970 1:00 am”]

I tried several format :
[‘Jan 10 2020, 01:00 am’; ‘Feb 10 2020, 01:00 pm’]
[‘01/10/2020 01:00 am’; ‘02/10/2020 01:00 pm’]
[‘01-10-2020 01:00 am’; ‘02-10-2020 01:00 pm’]

But nothing works.

Any idea how to make it work ?

Thanks in advance.

[SerPounce]

So interesting… I was having similar trouble and the dates were coming in as 01/01/1969.

Here is my format in excel that works:

[keith]

I’d file a bug report / request for enhancement with support. Date ranges are a Bubble custom datatype and are sort of poorly supported.

(For example, even if you send a properly formatted Date Range via the API connector, Bubble won’t let you detect it as such.)

Internally, Date Ranges are a 2-element array of JavaScript dates (so they look much like you’ve formatted them in your post… but I’m not sure what formatting you need from CSV to import a cell as a date range (or even if it’s possible). Did you consult the reference? It’s possible there may be a hint there.

[christo1]

I tried this in my sheet and it worked: “8/1/2022 12:00 am”,“8/31/2022 11:59 pm”

Using American date formats