Converting object values to string or date range format

Queries and Resources
1

Hi guys! I know this a very noob question that I'm asking and I'm very sorry, but I would like to know how can I convert a object value into a string or better yet into a date range format? such as "2000-01-01 - 2001-02-02" or "January 1, 2000 - January 20, 2000".

I'm very sorry again for this question, sine my knowledge in JavaScript isn't advance. I would very appreciate the help.

table 2 query 2
table 2 query 21043×460 39.5 KB

table2 query
table2 query1043×460 40.4 KB

2

Are you trying to convert a DateTime object into a string, if I'm not wrong?

You can use the moment library in Retool. moment(your date obj).format("LL").

3

Thanks it worked! however, it only shows the start date value. I wanted it to show both start and end.

image
image999×241 26.3 KB

I manage to do it with .start and .end

image
image1038×209 25.6 KB

However, I would like the format to be:
March 15, 2023 - April 20, 2023

4

You can generate the same string output. I've used a date range component and a JavaScript query to generate your desired format.

image
image1294×474 31.3 KB

5

Thanks! this helps a lot! :grin:

6