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

Question

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

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

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

Phil Parkin SSC Guru Points: 246959 More actions · Answer 1

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

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Griffster SSCertifiable Points: 7097 More actions · Answer 2

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.

Phil Parkin SSC Guru Points: 246959 More actions · Answer 3

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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin