All topics

Date format error

Vizualinx

6 months ago

I'm trying to post data to supabase. i'm getting a date format error (see screenshot). i tried using 'date from string' formula, but it returns undefined.
Armand

6 months ago

If I'm not mistaken, the date/time should be formatted as:
1. Full timestamp with timezone: YYYY-MM-DDTHH:MM:SSZ
2. Date-only: YYYY-MM-DD

So you can try this to get it right before you send it to Supabase:
@Armand
If I'm not mistaken, the date/time should be formatted as:
1. Full timestamp with timezone: YYYY-MM-DDTHH:MM:SSZ
2. Date-only: YYYY-MM-DD

So you can try this to get it right before you send it to Supabase:
Vizualinx

6 months ago

Thanks, will try that.
@Armand
If I'm not mistaken, the date/time should be formatted as:
1. Full timestamp with timezone: YYYY-MM-DDTHH:MM:SSZ
2. Date-only: YYYY-MM-DD

So you can try this to get it right before you send it to Supabase:
Vizualinx

6 months ago

i'm getting null.
date from string also doesn't work. just getting undefined.
Armand

6 months ago

I think it is still an object. Can you try to to use the String node and then the Date from String node?
Vizualinx

6 months ago

You mean something like this?? @Armand
Armand

6 months ago

This should solve it
but it seems quite elaborate. I wonder if this is a bug. @Erik Beuschau any idea if something is not working here? Or did I just never encounter a date in that format in Toddle before?
Erik Beuschau

6 months ago

The Date from string formula uses the regular Date() constructor documented here https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/Date
It only supports a few specified time formats https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date#several_ways_to_create_a_date_object
From your example, it appears you're using a european format (dd/mm/yyyy) which would not be supported. mm/dd/yyyy does seem to work though
👍1
Vizualinx

6 months ago

Thank you so much @Armand ! that worked!!
Team toddle is this how it is supposed to work?
@Erik Beuschau
The Date from string formula uses the regular Date() constructor documented here https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/Date
It only supports a few specified time formats https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date#several_ways_to_create_a_date_object
From your example, it appears you're using a european format (dd/mm/yyyy) which would not be supported. mm/dd/yyyy does seem to work though
Armand

6 months ago

Ok, that makes sense

Date format error

Vizualinx

Armand

Vizualinx

Vizualinx

Armand

Vizualinx

Armand

Erik Beuschau

Vizualinx

Armand