I often have to look up old conversion rates and match them to items that was paid at a specific dates.
I’ve been playing around with the scripting block and been trying to figure out if I can get a drop-down calendar in my block, however it seems not possible atm.
For now I’m thinking I want to be able to pass an input string, have that to lookup historic currency rates.
However I’m alittle stuck on getting to grips with how to format dates.
I would have thought the below would send me the input date, however I get nothing atm.
let table = base.getTable('Match currency to date') let date = await input.textAsync('Choose a date you want to look up') let checkDate = new Date(date); console.log(checkDate.getDate)