Im trying to filter data between 8 november 2023 & 10 november 2023, the date range filter works but to get the data i need, i need set
start date = 8 november 2023
end date = 11 november 2023
why does the end date needs to be 11 november if i want the data only up to 10 november ?
Note: my data is coming from xano
the date without hours secified is the beginning of the day. If you want to include the whole day of your end date you need to either pick 23:59 of that day or the beginning of the next day (11 november).
Often this distinction is not clear for the end user that just selects 10 november. You need to transform the date to include the whole day before requesting the data from xano.
Ok its working fine now but i didn’t do it the No code way.
Can you help do it the No code way ? im trying to stay with no code as much as possible
this is my code below
const startDate = variables[/* Transaction Date range picker - value */ 'e20f742c-5732-4547-9fb5-de6c47ba42ae-value']?.['start']
// Parse the date string into a JavaScript Date object
let startDateObject = new Date(startDate);
// Set the time to the beginning of the day (00:00:00) in local timezone
startDateObject.setUTCHours(0, 0, 0, 0);
const startTimeStamp = pluginFormulas[/* dayjs */'832d6f7a-42c3-43f1-a3ce-9a678272f811']['toTimestamp'](startDateObject.toISOString())
return startTimeStamp