I have the following formula to set the entry for "Current Month": DATETIME_FORMAT({ Start Time}, 'YYYY-MM') = DATETIME_FORMAT(NOW(), 'YYYY-MM') It seems to be working just fine, however the last entry from last month is setting the formula to 1.If ...
I’m creating a vehicle fuel log. I’d like to calculate the miles driven between fill ups (trip). After that, then I will be able to easily calculate the miles-per-gallon (MPG).
I know I could easily accomplish this by adding a column for “start odome...
Update: I guess I can use the “month count” formula instead that works and returns zeros for every current month entry.(DATETIME_FORMAT({ Date}, 'MM') - DATETIME_FORMAT(TODAY(), 'MM')) +((DATETIME_FORMAT({ Date}, 'YYYY') - DATETIME_FORMAT(TODAY(), ...
Thanks @Semsongleng-KH! Here is what worked for me ( @Sho SET_TIMEZONE appears to be working fine for me) DATETIME_FORMAT(SET_TIMEZONE({ Start Time}, 'America/Chicago'), 'YYYY-MM') = DATETIME_FORMAT(NOW(), 'YYYY-MM') I also have a "Is Last Month" ...
@kuovonne Your implementation works perfect! Also thanks @ScottWorld That works too, but I definitely wanted to keep the date as the primary field.
Also thanks @kuovonne and @Bill.French for noting the use cases. They all apply for me.
I’ve actually ...
