Comments by Member 13485232 (Top 2 by date)

Member 13485232 25-Oct-17 15:40pm View

Yes. That is what I am looking for. I simply do not know what the date format is called. My thinking is that if I knew the name of that format, I could research it a little more.
I have written a SQL function to parse it, but I have to query it via Openquery because it is a Progress database that has been set up as a Linked Server. So essentially, I pull the data and then parse the results and then search by the parsed date. I would like to be able to pull the data by the date criteria from the get-go...but can't because I can only parse the full result set...which leads to some long execution times (because of the linked server).

I just want to make sure there's not something I am missing.

Member 13485232 25-Oct-17 13:44pm View

So its A = 200, B = 201 , C = 202. So 2017 = B7. The next part is MMDD...so yes, US-format.
I'm just curious is anybody has worked with this format before. If so, is there a better way of parsing that data.