Posts Tagged ‘date’

Erroneous “This modification will affect transactions from closed periods…” prompt in Quickbooks

Friday, May 8th, 2015

I was highly disappointed to discover that a current version of QuickBooks will give this error message:quickbooks-depends-on-computer-date-format

 

 

If you have your Windows user date format set differently from the other users of QuickBooks – I assume that it would work on some days and not others! At this particular client’s site, 2 users were using a mm/dd/yyyy date format, and the 3rd, the person who couldn’t make postings, was using dd/mm/yyyy. I was able to triage this to a Windows user issue, since other QuickBooks users using this fellows Windows login also were not able to make postings.

It took a few tries while searching Google to find the magic search terms to confirm that I wasn’t the first to find this particular issue.

It is 2015, I would have bet that a very common software package from a large firm would have had time to learn to convert dates to a single standard, maybe UTC,  prior to applying business logic. But… I would have lost that bet with QuickBooks.

Meh, I guess this gives us something to point to when people find bugs in our websites. :)

Clean Up a Column of Mixed Date Formats Tool

Sunday, December 12th, 2010

A few times a year, a client of our will need our help in cleaning up a manually populated Excel file that has a couple of date columns. Invariably, there is a hodge-podge of date entries, such as 2010-10-05;  june 10, 2010; or 8/4/2008.  We’ve finally made a tool to fix up the bulk of this so that Excel will detect it properly as a date value.

Perceptus introduces the  Clean and convert a column of dates in Excel Numbers Wizard, on the Perceptus Web Tools mini-site.

We hope this tool saves some people besides ourselves some time.