Thank you, David,
I have looked at my database and everything there (5 blogs) is stored with the offset (but naturally as Y-m-d), even Sliced Invoices created and saved within the date offset. So, even though SI “thought” it was created on 2018-04-24 23:30, the database saved it as 2018-04-25 01:30.
I have also looked at other plugins on my websites. They all seem to save local time (online payments through third parties included). So what exactly do you mean with “we always store in GMT”? Just trying to wrap my head around it. LOL.
I ran into the CMB2 date issue if other things as well. It seems like you used the current_time() as a workaround for that already. ??
There are currently no formatting options for displaying dates within SI. So I ended up completely rebuilding the invoice template (front-end) from scratch, because Dutch invoices never use Y-m-d, but always d-m-Y. (From scratch was also my own choice, of course). A little test (reusing the original template with the get_option(date_format) in the code, seems to work just fine.
So I will test things at my end as well. I know it’s very hard to make an international plugin with dates and finances – especially for the Dutch. We tend to have different rules than most. Currency, postcodes, etc.
Dutch: € 49,95
German: 49,95€
We always have issues with commas and dots in currency: visually we use commas, but technically dots are required, as commas break arrays. This is the main reason why I had to abandon Gravity Forms with Sliced Addon… The form used commas, so Sliced imported € 49,95 as € 49950.00.
I have tried a lot of plugins for invoicing, and luckily Sliced comes very close! So I am very happy with it. ??