petebocken - profile

petebocken · Oct 09, 2023

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 ...

petebocken · Apr 30, 2022

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...

petebocken · Feb 01, 2016

Touch ID/PIN should be implemented to secure the app.

petebocken · Dec 29, 2023

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(), ...

petebocken · Oct 10, 2023

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" ...

petebocken · May 03, 2022

@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 ...

User Statistics

User Activity

Current Month formula grabbing last entry of last month

Vehicle Fuel Log - calculating miles driven between fill ups and MPG

iOS Touch ID/PIN security

Re: Current Month formula grabbing last entry of last month

Re: Current Month formula grabbing last entry of last month

Re: Vehicle Fuel Log - calculating miles driven between fill ups and MPG