How to format datetime? I want to return it in a message as "Monday 31 July 2023" but instead I'm getting "2023-07-31T00:00:00.000Z"

hint: just ask chatGPT. It came up with this right here, try if it works: const dateString = "2023-07-31T00:00:00.000Z"; const date = new Date(dateString); const options = { weekday: 'long', day: 'numeric', month: 'long', year: 'numeric' }; const formattedDate = date.toLocaleDateString('en-US', options); console.log(formattedDate); // Output: Monday, July 31, 2023 if it doesn't, ask chatGPT why. AI can help you with literally anything. 🙂

Thanks, that looks impressive. Umm, now where does it go? Slowly finding that this no code chatbot isn't really designed for beginners scratches head

Here's a step-by-step for you: 1. Make the flow from the picture. 2. Ensure the capture card in "get_the_date" is of the "datetime" type. It's at the very bottom of the list. 3. Store the result in a new variable called "userDate" 4. Add an "Execute code" card with the following code:

js
const date = new Date(workflow.userDate)
const options = {
  weekday: 'long',
  day: 'numeric',
  month: 'long',
  year: 'numeric'
}

const formattedDate = date.toLocaleDateString('en-us', options)
workflow.date = formattedDate

5. After the execute code card, add a text card with

@date

written in it. Test it out and let me know if it works 🙌

Thanks for the info above. I tested it and when I use @date it displays a value 1 day before the actual date the chatbot user entered. Chatgpt suggested "The issue you are facing is likely due to JavaScript treating the timestamp as UTC and converting it to your local timezone when creating the Date object. For a more robust solution handling multiple timezones, consider using a library like moment.js or date-fns. These libraries offer more extensive and intuitive controls for handling date and time operations." I tried to ask ChatGpt but didnt get far so any further advice would be greatly received. ps. A Date picker would be magic! There's aready a feature request.

A datepicker would be pretty cool, I agree! Until then, you can try this code. Moment isn't included by default by Luxon is and they do about the same job.

js
const userTimeZone = Intl.DateTimeFormat().resolvedOptions().timeZone
console.log(userTimeZone)
const date = luxon.DateTime.fromJSDate(new Date(workflow.userDate), { zone: userTimeZone })
const formattedDate = date.toFormat('cccc, MMMM d, yyyy')
workflow.date = formattedDate

If things are still weird, look in the logs and you should see what time zone it thinks you're in. You can always manually adjust the time zone by changing the

zone

param on line 3

That didn't work, after some chats with the almighty GPT I got this code, which seems to be working. As I explained to ChatGPT the date is fixed, like a birthday, it makes no difference what time zone the user or server is in, the birthday is always on a set date. // Convert classStart Date object to ISO string and split to get the date const classStartDate = workflow.classStart.toISOString().split('T')[0]; // Parse the date const date = luxon.DateTime.fromISO(classStartDate); const formattedDate = date.toFormat('cccc, MMMM d, yyyy'); workflow.date = formattedDate; Looking forward to the date picker 😉