Downloaded transactions in Quicken Premier 2018 for Windows error message "Please Enter Valid Date".

  • 0
  • 3
  • Problem
  • Updated 4 days ago
  • Solved
Cannot "accept" or enter any downloaded transactions in to Register.  Continue to get "Please Enter Valid Date".  I enter valid date with a 4 digit year and clears field and shows error message dialogue box again.  Started entry of a transaction on new line and it was able to be entered.  Is anyone else having this issue with downloaded transactions?
Photo of BigKev

BigKev

  • 220 Points 100 badge 2x thumb

Posted 3 months ago

  • 0
  • 3
Photo of UKR

UKR, SuperUser

  • 363,474 Points 100k badge 2x thumb

What kind of a Date format are you using? US mm/dd/yyyy e.g., 10/29/2017 or something else?

The Date format is controlled by the settings in Windows Control Panel, Region, Short Date.

What bank are you downloading from?


Can you please capture one or more images of the parts of your Quicken window showing the issue, redacted as necessary to protect your privacy but annotated to describe the situation, and attach the image(s) here?
The Windows Snipping Tool (available with Windows 7 and up) can be used to capture a partial screen image and save it to a file.  Microsoft Paint can be used to annotate the image.
To take a screenshot in Mac please see https://support.apple.com/en-us/HT201361
Please create image files of type PNG, JPG or BMP only.
To attach the image here, start composing your reply. At the bottom of the text entry window you'll see a row of icons beginning with B I U S
Click the camera icon (not the video camera icon). It will allow you to select and upload the captured image file from your computer. The captured image will be inserted at wherever the cursor is located in the text.

Photo of BigKev

BigKev

  • 220 Points 100 badge 2x thumb
Thanks for the quick reply.  I just re-booted Quicken and went back in to capture the screen images and the transactions were accepted.  So, I guess it was an odd bug or something.  Thanks again.
Photo of Tim Marciniak

Tim Marciniak

  • 166 Points 100 badge 2x thumb
Every time I try to change a downloaded transaction date I get that error too.
Photo of BigKev

BigKev

  • 220 Points 100 badge 2x thumb
Hey Tim...in Windows 10 I went to Control Panel and chose Region.  In that menu I changed the date format to MM/dd/yyyy (mine was set to M/dd/yyyy) and the transactions started being accepted.  Hope that works for you.
Photo of Tim Marciniak

Tim Marciniak

  • 166 Points 100 badge 2x thumb
Thanks! We'll see at the next download. I like my transactions to have the date we incurred the expense not the day it posted.
Photo of UKR

UKR, SuperUser

  • 363,164 Points 100k badge 2x thumb

Tim,
you said: "I like my transactions to have the date we incurred the expense not the day it posted."

In that case you need to enter all your transactions manually before downloading from the bank. The bank can only give you the Posting Date, i.e., the date that the bank received your transaction for processing ... which can be 1 or more days after you made your purchase.
If Quicken receives a downloaded transaction which matches an existing register entry it will match the two together without changing the transaction date in the register.

Photo of Bob

Bob

  • 274 Points 250 badge 2x thumb
Not quite true that "The bank can only give you the Posting Date." Some banks do actually download the transaction date, though the majority of banks I deal with download the posting date. There is no consistency.
When I enter the transaction regardless of the bank  It does not show as entered, if I repeat the entry then tells to enter valid date and does not accept my efforts to enter the date, then close the account, reopen and there it is the transaction and it ask me to match and then it is accepted. This is totally unacceptable
Photo of bcbeatty

bcbeatty

  • 154 Points 100 badge 2x thumb
I just downloaded Q2018, and I'm on Windows 10. I also get this error.
It's preventing me from accepting any downloaded transactions.
My windows date format is already M/d/yyyy.

Considering this is a 3 month old bug. I would have expected this to be fixed.
Photo of Clayton

Clayton

  • 3,986 Points 3k badge 2x thumb
"I like my transactions to have the date we incurred the expense not the day it posted."

I manually enter ALL my transactions and then match them up with the download. I opted to use both the Date Column AND the Posting Date Column. In Quicken 2018 for Windows select it in the Register View, click the gear icon and go down to Register Columns.

Please excuse me if I'm telling you something you already know.
(Edited)