Post reply

Converting a date in string format to a date field in UK format

  • October 26, 2009 at 9:52 am

    #1070787

    Sounds like it's going into Excel as text to me.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • October 26, 2009 at 9:54 am

    #1070789

    Yes, I agree. At a loss how to force writing to a date field (or custom date and time formatted field) really. There doesn't seem to be any means of configuring the destination field format unless you can point me otherwise.

  • October 26, 2009 at 10:01 am

    #1070795

    If no one else answers in the meantime, I will try to set up a test later. There must be a way! What about firing in the number which Excel is actually holding for date fields (eg, 40178 for 31/12/2009)?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply