Results 1 to 4 of 4

Thread: message string was not recognized as a valid datetime. pastel

  1. #1
    New Member
    Join Date
    Apr 2018
    Location
    Extension 2
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    message string was not recognized as a valid datetime. pastel

    Good day,

    Am having a problem importing CSV to Pastel Bank Managet,

    This is the message i get "message string was not recognized as a valid datetime. pastel"

    What might be the problem because i have checked my date is correct.

    Thank you

  2. #2
    Email problem
    Join Date
    Apr 2018
    Location
    Stilbaai
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Good day,

    I have the exact same problem.....
    Don't know what to do....

  3. #3
    New Member
    Join Date
    Jul 2020
    Location
    uae
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ParseExact

    Use DateTime.ParseExact.- Converts the specified string representation of a date and time to its DateTime equivalent using the specified format and culture-specific format information. The format of the string representation must match the specified format exactly. ParseExact and TryParseExact allows to use a custom format string.

    DateTime date = DateTime.ParseExact(strDate, "dd/MM/yyyy", CultureInfo.InvariantCulture);

    The IFormatProvider parameter specifies the culture to use to parse the date. Unless your string comes from the user, you should pass CultureInfo.InvariantCulture. If the string does come from the user, you should pass CultureInfo.CurrentCulture, which will use the settings that the user specified in Regional Options in Control Panel.

  4. #4
    New Member
    Join Date
    Feb 2024
    Location
    Langebaan
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Good morning.

    I think I have found the 'hack' that works for me.

    I make sure the date collum is formatted to 'date - English (Australia).

    Sometimes I still get this date error when I try to import the CSV file, then I have found that after saving the CSV, the changes revert back to 'general'. I have no idea why, or how to fix this as the settings continue to revert back after multiple attempts to resave.
    So, then I take the date from the 'error giving CSV' and insert those date lines into a spreadsheet that I know does not give the error. I then make sure the date is in the correct format and delete the original un-needed data and resave. This seems to work and I am then able to import the data that I need.

    Not a very scientific or IT answer, but it does seem to work.

    Good luck !!

Similar Threads

  1. [Question] Pastel Partner Ver 12 Date Error message
    By Hmasiye in forum Accounting Forum
    Replies: 1
    Last Post: 16-Feb-15, 06:51 AM
  2. PASTEL 2005 DISC ERROR MESSAGE
    By Coolblue in forum Accounting Forum
    Replies: 0
    Last Post: 18-Mar-13, 08:21 AM
  3. [Question] Best Overdue Message on Statements Pastel Xpress
    By fuzegraphics in forum Accounting Forum
    Replies: 2
    Last Post: 12-Dec-12, 04:03 PM
  4. Any Pastel users having a VAT error message this month?
    By Neville Bailey in forum General Business Forum
    Replies: 0
    Last Post: 31-Dec-10, 09:18 AM

Tags for this Thread

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •