Format Correct Between

Arthur Sanchez — Fri, 13 Sep 2024 15:11:35 GMT

Guys, please help me, what is the correct format to use between in a get request to get time intervals?

// const startDate = '2024-09-11 00:00:00'; // const endDate = '2024-09-12 23:59:59'; // const between = `opened_atBETWEEN${startDate}@${endDate}`

I want to make a get request to get a specific time interval but this way it is not bringing all the data, so I don't know if there is something missing in the format, please help me.

I'm creating a function to automatically get yesterday's and today's data, but I don't know if the format is correct:

import { subDays, startOfDay, endOfDay, format } from 'date-fns'; // Pega a data de ontem e formata para começar à meia-noite const yesterdayStart = startOfDay(subDays(new Date(), 1)); const todayEnd = endOfDay(new Date()); // Data de hoje até as 23:59:59 // Função para formatar a data no padrão que a API espera (YYYY-MM-DD HH:MM:SS) const formatDate = (date: Date): string => { return format(date, 'yyyy-MM-dd HH:mm:ss'); }; // Define as variáveis de data const startDate = formatDate(yesterdayStart); // Meia-noite de ontem const endDate = formatDate(todayEnd); // 23:59:59 de hoje // Comando BETWEEN para filtrar entre as duas datas const between = `opened_atBETWEEN${startDate}@${endDate}`;

question Format Correct Between in Community Central forum

Format Correct Between