Managing data fields

At a glance

The community member is creating a bot to schedule appointments and needs to convert the date format from DD/MM/YYYY or YYYY/MM/DD to the ISO format (AAAAMMGGTHHMMSSZ). The community members discuss how to convert the date format, including using JavaScript to split the date string and convert it to the ISO format. They also discuss how to manage the date and time fields in the bot, and how to convert the ISO format back to a more readable format (DD/MM/YYYY HH:MM) for use in emails. However, there is no explicitly marked answer in the comments.

MMario Barretta

I'me creating a bot to schedule appointment and the date format requested is ISO (AAAAMMGGTHHMMSSZ)

How can i do to use this format on our date bubble in typebot? that have the format DD/MM/YYYY or YYYY/MM/DD ?

Thank you

4 comments

..Enzo

Example:

Plain Text

const dateString = "12/07/2034";
const [day, month, year] = dateString.split('/');
const date = new Date(year, month - 1, day); 
const iso = date.toISOString()

MMario Barretta

thank you very much for reply (sorry but i did not received the notify about it.

can i ask you how do i use this?
i need insert this in a variable block?
My flow is that user insert a data in format DD/MM/YYYY but i need that this become in the other format and will be applied to a variable that i use in a string that will be used for a link,

MMario Barretta

I've found a workarouund and i can use the date with hout in this format YYYYMMDDTHHMM

So i "only" need to understand how to mangage the field DATE (now in YYYY/MM/DD) and HOUR ( i do not have found a bubble with this but only date and time how for example YYYY/MM/DD HH:MM)

So to have a variable {{DATE}}T{{HOUR}} that will be added to my link to have HTTPS://www.site.ext/{{DATE}}T{{HOUR}}

MMario Barretta

I'm continuining to develop the bot and now i've an othe problem
How written at begin i need to take date's fileds with this format

20240701T204800 (yyyyMMdd'T'HHmmss)

But i can not use this variable in my mails so i'd need to found a solution to can convert

20240701T204800 (yyyyMMdd'T'HHmmss) variable -->

in

01/07/2024 20:48 (dd/MM/yyyy HH:mm)

Someone has idea on how to do this

Actually i show an other request asking to user to refill the same data and hout ofr an other time but is really a bad bad bad solution so i'd like to can converti it or to found a way to take previous vale and use it assigning it to a new variable {{BeginW}} that have to be the same value (with oher format) of {{Begin}}

Add a reply

Share feedback, ideas and get community help

Managing data fields