Spreadsheet: 64252d1265131509-how-to-convert-data-into-uk-date-format-example
Sheet: Sheet1

bookdate | clienref | fromdate | todate | propref | quan | class | type
12/30/2008 11:14 | CURD003 | 2009-06-02 00:00:00 | 2009-09-02 00:00:00 | CAR | 2 | X | CAR | 2009-02-09 00:00:00
2/19/2009 12:21 | RAER001 | 2/24/2009 | 2/28/2009 | CAR | 1 | X | CAR | #N/A
2/27/2009 16:03 | RAER001 | 2/24/2009 | 2/28/2009 | CAR | -1 | X | CAR | #N/A
12/29/2008 13:30 | HAMD005 | 2009-08-04 00:00:00 | 4/15/2009 | CAR | 1 | X | CAR | #N/A
2009-06-04 13:05:00 | RUSJ009 | 4/14/2009 | 4/18/2009 | CAR | 1 | X | CAR | #N/A
2/20/2009 11:59 | VEIM001 | 5/16/2009 | 5/23/2009 | CAR | 2 | X | CAR | #N/A
6/17/2009 15:13 | THOR014 | 6/27/2009 | 2009-04-07 00:00:00 | CAR | 1 | X | CAR | 2009-07-04 00:00:00
2009-07-01 17:41:00 | [NAME] | 2009-11-07 00:00:00 | 7/18/2009 | CAR | 4 | X | CAR | #N/A
2/17/2009 15:12 | [NAME] | 7/18/2009 | 7/25/2009 | CAR | 6 | X | CAR | #N/A
2009-05-01 09:34:00 | ATWM001 | 7/25/2009 | 2009-01-08 00:00:00 | CAR | 2 | X | CAR | 2009-08-01 00:00:00
2008-12-09 14:23:00 | CANJ006 | 2009-01-08 00:00:00 | 2009-08-08 00:00:00 | CAR | 1 | X | CAR | 2009-08-08 00:00:00
2009-01-05 14:39:00 | CANJ006 | 2009-01-08 00:00:00 | 2009-08-08 00:00:00 | CAR | -1 | X | CAR | 2009-08-08 00:00:00
2009-01-05 14:39:00 | CANJ006 | 2009-01-08 00:00:00 | 2009-08-08 00:00:00 | CAR | 1 | X | CAR | 2009-08-08 00:00:00
2009-11-08 14:54:00 | MILH003 | 8/15/2009 | 8/22/2009 | CAR | 1 | X | CAR | #N/A
2009-01-05 11:09:00 | ADAA006 | 8/29/2009 | 2009-05-09 00:00:00 | CAR | 1 | X | CAR | 2009-09-05 00:00:00
2009-10-05 11:17:00 | SETK001 | 8/29/2009 | 2009-05-09 00:00:00 | CAR | 1 | X | CAR | 2009-09-05 00:00:00
2009-10-07 17:42:00 | CORM005 | 2009-05-09 00:00:00 | 9/18/2009 | CAR | 2 | X | CAR
6/16/2009 14:15 | [NAME] | 2009-12-09 00:00:00 | 9/19/2009 | CAR | 1 | X | CAR
7/14/2009 16:19 | MORT011 | 2009-12-09 00:00:00 | 9/20/2009 | CAR | 1 | X | CAR
7/27/2009 14:54 | AUGB001 | 9/19/2009 | 9/26/2009 | CAR | 2 | X | CAR
8/30/2009 15:28 | PADA001 | 9/26/2009 | 2009-03-10 00:00:00 | CAR | 2 | X | CAR
8/17/2009 18:19 | DAVH006 | 2009-09-10 00:00:00 | 10/16/2009 | CAR | 2 | X | CAR
8/20/2009 17:01 | DAVH006 | 2009-09-10 00:00:00 | 10/16/2009 | CAR | -2 | X | CAR
8/20/2009 17:01 | DAVH006 | 2009-09-10 00:00:00 | 10/16/2009 | CAR | 2 | X | CAR
7/27/2009 11:02 | SHAE004 | 10/19/2009 | 10/23/2009 | CAR | 2 | X | CAR
9/30/2009 11:23 | DE C004 | 10/21/2009 | 10/24/2009 | CAR | 1 | X | CAR
2009-06-02 16:33:00 | CHIL005 | 2009-07-11 00:00:00 | 11/14/2009 | CAR | 1 | X | CAR
10/23/2009 14:03 | [NAME] | 7/18/2009 | 7/25/2009 | XDMGNV | 1 | X | XDMGNV
10/23/2009 14:04 | BYFA001 | 2009-01-08 00:00:00 | 2009-08-08 00:00:00 | XDMGNV | 1 | X | XDMGNV
2009-11-12 09:07:00 | BATL003 | 9/19/2009 | 9/26/2009 | XDMGNV | 1 | X | XDMGNV
1/25/2010 15:15 | NORM006 | 10/23/2009 | 10/29/2009 | XDMGNV | 1 | X | XDMGNV
12/14/2009 12:00 | TALM003 | 11/26/2009 | 11/29/2009 | XDMGNV | 1 | X | XDMGNV
12/14/2009 12:01 | TALM003 | 11/26/2009 | 11/29/2009 | XDMGNV | 1 | X | XDMGNV
12/14/2009 12:03 | TALM003 | 11/26/2009 | 11/29/2009 | XDMGNV | -1 | X | XDMGNV
12/14/2009 12:03 | TALM003 | 11/26/2009 | 11/29/2009 | XDMGNV | -1 | X | XDMGNV
1/14/2009 17:48 | WALD013 | 12/31/2008 | 2009-04-01 00:00:00 | XDMGS | 1 | X | XDMGS
2009-07-04 20:09:00 | MORV002 | 3/23/2009 | 3/27/2009 | XDMGS | 1 | X | XDMGS
2009-06-05 16:41:00 | MORV002 | 3/23/2009 | 3/27/2009 | XDMGS | -1 | X | XDMGS
4/20/2009 10:51 | ROBP016 | 2009-10-04 00:00:00 | 4/13/2009 | XDMGS | 1 | X | XDMGS
2009-01-05 16:17:00 | [NAME] | 4/23/2009 | 4/27/2009 | XDMGS | 1 | X | XDMGS
2009-06-05 12:56:00 | WESM013 | 2009-01-05 00:00:00 | 2009-04-05 00:00:00 | XDMGS | 1 | X | XDMGS
6/15/2009 10:42 | WESM013 | 2009-01-05 00:00:00 | 2009-04-05 00:00:00 | XDMGS | -1 | X | XDMGS
5/29/2009 15:33 | PARC024 | 2009-09-05 00:00:00 | 5/16/2009 | XDMGS | 1 | X | XDMGS
2009-09-06 17:40:00 | WARC018 | 2009-09-05 00:00:00 | 5/16/2009 | XDMGS | 1 | X | XDMGS
6/18/2009 15:24 | WARC018 | 2009-09-05 00:00:00 | 5/16/2009 | XDMGS | -1 | X | XDMGS
5/21/2009 13:19 | ATTA001 | 5/13/2009 | 5/17/2009 | XDMGS | 1 | X | XDMGS
5/27/2009 18:38 | DEKH001 | 5/16/2009 | 5/19/2009 | XDMGS | 1 | X | XDMGS
2009-02-06 12:19:00 | GILM004 | 5/23/2009 | 5/30/2009 | XDMGS | 1 | X | XDMGS
6/22/2009 14:22 | GILM004 | 5/23/2009 | 5/30/2009 | XDMGS | -1 | X | XDMGS
2009-10-07 18:06:00 | REA007 | 6/20/2009 | 6/27/2009 | XDMGS | 1 | X | XDMGS
7/17/2009 12:49 | REA007 | 6/20/2009 | 6/27/2009 | XDMGS | -1 | X | XDMGS
2009-06-07 11:57:00 | WARL009 | 6/20/2009 | 6/27/2009 | XDMGS | 1 | X | XDMGS
8/18/2009 15:20 | WARL009 | 6/20/2009 | 6/27/2009 | XDMGS | -1 | X | XDMGS
2009-03-07 18:34:00 | BRAD003 | 6/20/2009 | 6/27/2009 | XDMGS | 1 | X | XDMGS
8/20/2009 17:09 | BRAD003 | 6/20/2009 | 6/27/2009 | XDMGS | -1 | X | XDMGS
2009-07-07 13:09:00 | CLAF003 | 6/24/2009 | 2009-01-07 00:00:00 | XDMGS | 1 | X | XDMGS
8/20/2009 17:18 | CLAF003 | 6/24/2009 | 2009-01-07 00:00:00 | XDMGS | -1 | X | XDMGS
8/18/2009 13:38 | GRID004 | 6/22/2009 | 2009-02-07 00:00:00 | XDMGS | 1 | X | XDMGS
8/19/2009 17:36 | GRID004 | 6/22/2009 | 2009-02-07 00:00:00 | XDMGS | -1 | X | XDMGS
7/14/2009 19:05 | SUDY001 | 6/27/2009 | 2009-04-07 00:00:00 | XDMGS | 1 | X | XDMGS
2009-03-08 11:46:00 | ECKA002 | 2009-04-07 00:00:00 | 2009-11-07 00:00:00 | XDMGS | 1 | X | XDMGS
2009-03-08 11:46:00 | ECKA002 | 2009-04-07 00:00:00 | 2009-11-07 00:00:00 | XDMGS | -1 | X | XDMGS
7/24/2009 13:30 | BARJ007 | 2009-04-07 00:00:00 | 7/18/2009 | XDMGS | 1 | X | XDMGS
2009-04-08 11:27:00 | GARJ014 | 2009-11-07 00:00:00 | 7/18/2009 | XDMGS | 1 | X | XDMGS
8/18/2009 12:35 | GARJ014 | 2009-11-07 00:00:00 | 7/18/2009 | XDMGS | -1 | X | XDMGS
8/18/2009 12:35 | GARJ014 | 2009-11-07 00:00:00 | 7/18/2009 | XDMGS | 1 | X | XDMGS
2009-01-09 11:53:00 | GARJ014 | 2009-11-07 00:00:00 | 7/18/2009 | XDMGS | -1 | X | XDMGS
9/24/2009 10:51 | ARBA001 | 2009-11-07 00:00:00 | 7/18/2009 | XDMGS | 1 | X | XDMGS
2009-11-06 13:54:00 | PONI003 | 6/20/2009 | 7/18/2009 | XDMGS | 1 | X | XDMGS
8/26/2009 12:14 | ALED002 | 2009-11-07 00:00:00 | 7/18/2009 | XDMGS | 1 | X | XDMGS
8/18/2009 13:20 | OHAB001 | 7/18/2009 | 7/25/2009 | XDMGS | 1 | X | XDMGS
8/20/2009 15:48 | OHAB001 | 7/18/2009 | 7/25/2009 | XDMGS | -1 | X | XDMGS
2009-06-08 10:55:00 | KEAC002 | 7/18/2009 | 7/25/2009 | XDMGS | 1 | X | XDMGS
2009-06-08 11:10:00 | KEAC002 | 7/18/2009 | 7/25/2009 | XDMGS | -1 | X | XDMGS
2009-06-08 11:19:00 | KEAC002 | 7/18/2009 | 7/25/2009 | XDMGS | 1 | X | XDMGS
1/21/2010 11:19 | KEAC002 | 7/18/2009 | 7/25/2009 | XDMGS | -1 | X | XDMGS
8/18/2009 13:03 | KEMM004 | 7/18/2009 | 7/25/2009 | XDMGS | 1 | X | XDMGS
8/18/2009 13:43 | [NAME] | 7/18/2009 | 7/25/2009 | XDMGS | 1 | X | XDMGS
10/23/2009 14:03 | [NAME] | 7/18/2009 | 7/25/2009 | XDMGS | -1 | X | XDMGS
8/26/2009 12:26 | BYRJ003 | 7/18/2009 | 7/25/2009 | XDMGS | 1 | X | XDMGS
2009-01-09 12:11:00 | BYRJ003 | 7/18/2009 | 7/25/2009 | XDMGS | -1 | X | XDMGS
2009-08-01 14:38:00 | TAYR009 | 7/25/2009 | 2009-01-08 00:00:00 | XDMGS | 1 | X | XDMGS
2009-08-01 14:39:00 | TAYR009 | 7/25/2009 | 2009-01-08 00:00:00 | XDMGS | -1 | X | XDMGS
2009-08-01 14:42:00 | TAYR009 | 7/25/2009 | 2009-01-08 00:00:00 | XDMGS | 1 | X | XDMGS
2009-08-01 14:42:00 | TAYR009 | 7/25/2009 | 2009-01-08 00:00:00 | XDMGS | -1 | X | XDMGS
2009-08-01 14:42:00 | TAYR009 | 7/25/2009 | 2009-01-08 00:00:00 | XDMGS | 1 | X | XDMGS
2009-07-08 10:54:00 | TAYR009 | 7/25/2009 | 2009-01-08 00:00:00 | XDMGS | -1 | X | XDMGS
2009-11-08 12:53:00 | YATR002 | 7/25/2009 | 2009-01-08 00:00:00 | XDMGS | 1 | X | XDMGS
2009-01-09 11:57:00 | YATR002 | 7/25/2009 | 2009-01-08 00:00:00 | XDMGS | -1 | X | XDMGS
7/28/2009 14:14 | ANTL002 | 7/25/2009 | 2009-01-08 00:00:00 | XDMGS | 1 | X | XDMGS
8/26/2009 12:25 | BORA001 | 2009-01-08 00:00:00 | 2009-08-08 00:00:00 | XDMGS | 1 | X | XDMGS
2009-01-09 12:11:00 | BORA001 | 2009-01-08 00:00:00 | 2009-08-08 00:00:00 | XDMGS | -1 | X | XDMGS
8/20/2009 14:57 | BYFA001 | 2009-01-08 00:00:00 | 2009-08-08 00:00:00 | XDMGS | 1 | X | XDMGS
10/23/2009 14:04 | BYFA001 | 2009-01-08 00:00:00 | 2009-08-08 00:00:00 | XDMGS | -1 | X | XDMGS
2009-05-10 12:31:00 | FEAF001 | 8/22/2009 | 8/29/2009 | XDMGS | 1 | X | XDMGS
2009-05-10 12:35:00 | FEAF001 | 8/22/2009 | 8/29/2009 | XDMGS | -1 | X | XDMGS
9/22/2009 10:30 | SUTM002 | 8/29/2009 | 2009-05-09 00:00:00 | XDMGS | 1 | X | XDMGS
2009-03-12 16:51:00 | SUTM002 | 8/29/2009 | 2009-05-09 00:00:00 | XDMGS | -1 | X | XDMGS
2009-03-10 13:48:00 | SAYM003 | 9/17/2009 | 9/20/2009 | XDMGS | 1 | X | XDMGS
2009-05-10 11:48:00 | SAYM003 | 9/17/2009 | 9/20/2009 | XDMGS | -1 | X | XDMGS
11/25/2009 16:15 | BATL003 | 9/19/2009 | 9/26/2009 | XDMGS | 1 | X | XDMGS
2009-11-12 09:07:00 | BATL003 | 9/19/2009 | 9/26/2009 | XDMGS | -1 | X | XDMGS
10/26/2009 12:21 | GRIK008 | 9/19/2009 | 9/26/2009 | XDMGS | 1 | X | XDMGS
2009-09-10 14:28:00 | MILS027 | 9/26/2009 | 9/29/2009 | XDMGS | 1 | X | XDMGS
1/21/2010 11:22 | MILS027 | 9/26/2009 | 9/29/2009 | XDMGS | -1 | X | XDMGS
11/16/2009 15:48 | [NAME] | 2009-10-10 00:00:00 | 10/13/2009 | XDMGS | 1 | X | XDMGS
11/16/2009 15:52 | [NAME] | 2009-10-10 00:00:00 | 10/13/2009 | XDMGS | -1 | X | XDMGS
10/26/2009 15:03 | SOOA001 | 10/20/2009 | 10/24/2009 | XDMGS | 1 | X | XDMGS
2009-12-11 13:38:00 | MAYS005 | 10/22/2009 | 10/25/2009 | XDMGS | 1 | X | XDMGS
2009-12-11 14:36:00 | MAYS005 | 10/22/2009 | 10/25/2009 | XDMGS | -1 | X | XDMGS
11/25/2009 10:02 | ELLM012 | 10/19/2009 | 10/29/2009 | XDMGS | 1 | X | XDMGS
2009-01-12 12:03:00 | GROC001 | 10/24/2009 | 10/31/2009 | XDMGS | 1 | X | XDMGS
12/14/2009 12:03 | TALM003 | 11/26/2009 | 11/29/2009 | XDMGS | 1 | X | XDMGS
12/14/2009 12:03 | TALM003 | 11/26/2009 | 11/29/2009 | XDMGS | 1 | X | XDMGS
10/17/2008 0:00 | REEJ010 | 12/26/2008 | 2009-02-01 00:00:00 | CWHC | 1 | X | CWHC
10/17/2008 16:10 | REEJ010 | 12/26/2008 | 2009-02-01 00:00:00 | CWHC | -1 | X | CWHC
2008-04-12 12:24:00 | REEJ010 | 12/26/2008 | 2009-02-01 00:00:00 | CWHC | 1 | X | CWHC
1/21/2010 11:00 | REEJ010 | 12/26/2008 | 2009-02-01 00:00:00 | CWHC | -1 | X | CWHC
1/21/2010 11:00 | REEJ010 | 12/26/2008 | 2009-02-01 00:00:00 | CWHC | 1 | X | CWHC
12/18/2008 0:00 | BEVA001 | 12/28/2008 | 2009-04-01 00:00:00 | CWHC | 1 | X | CWHC
12/18/2008 9:23 | BEVA001 | 12/28/2008 | 2009-04-01 00:00:00 | CWHC | -1 | X | CWHC
2009-02-02 00:00:00 | BLAB005 | 2009-04-02 00:00:00 | 2009-08-02 00:00:00 | CWHC | 1 | X | CWHC
2009-02-02 13:38:00 | BLAB005 | 2009-04-02 00:00:00 | 2009-08-02 00:00:00 | CWHC | -1 | X | CWHC
2/13/2009 0:00 | WISJ003 | 2/14/2009 | 2/18/2009 | CWHC | 1 | X | CWHC
2/13/2009 11:52 | WISJ003 | 2/14/2009 | 2/18/2009 | CWHC | -1 | X | CWHC
2/13/2009 11:52 | WISJ003 | 2/14/2009 | 2/18/2009 | CWHC | 1 | X | CWHC
2009-06-03 17:16:00 | WISJ003 | 2/14/2009 | 2/18/2009 | CWHC | -1 | X | CWHC
2009-06-03 17:16:00 | WISJ003 | 2/14/2009 | 2/18/2009 | CWHC | 1 | X | CWHC
2/16/2009 12:54 | COS005 | 2/16/2009 | 2/22/2009 | CWHC | 1 | X | CWHC
2/20/2009 0:00 | WIT003 | 2/21/2009 | 2/28/2009 | CWHC | 1 | X | CWHC
2/27/2009 14:45 | WIT003 | 2/21/2009 | 2/28/2009 | CWHC | -1 | X | CWHC
1/26/2009 0:00 | FOUD001 | 2009-01-03 00:00:00 | 2009-08-03 00:00:00 | CWHC | 1 | X | CWHC
2009-07-08 13:49:00 | FOUD001 | 2009-01-03 00:00:00 | 2009-08-03 00:00:00 | CWHC | -1 | X | CWHC
2009-07-08 13:50:00 | FOUD001 | 2009-01-03 00:00:00 | 2009-08-03 00:00:00 | CWHC | 1 | X | CWHC
1/19/2009 0:00 | HAMJ013 | 3/18/2009 | 3/22/2009 | CWHC | 1 | X | CWHC
6/22/2009 15:40 | [NAME] | 3/22/2009 | 3/26/2009 | CWHC | 1 | X | CWHC
2009-01-04 00:00:00 | MILG003 | 2009-03-04 00:00:00 | 2009-06-04 00:00:00 | CWHC | 1 | X | CWHC
2009-07-10 16:48:00 | MILG003 | 2009-03-04 00:00:00 | 2009-06-04 00:00:00 | CWHC | -1 | X | CWHC
2009-07-10 16:48:00 | MILG003 | 2009-03-04 00:00:00 | 2009-06-04 00:00:00 | CWHC | 1 | X | CWHC
3/23/2009 0:00 | VENP001 | 2009-10-04 00:00:00 | 4/13/2009 | CWHC | 1 | X | CWHC
3/23/2009 11:12 | VENP001 | 2009-10-04 00:00:00 | 4/13/2009 | CWHC | -1 | X | CWHC
5/13/2009 0:00 | HICN002 | 2009-09-04 00:00:00 | 4/16/2009 | CWHC | 1 | X | CWHC
5/13/2009 9:55 | HICN002 | 2009-09-04 00:00:00 | 4/16/2009 | CWHC | -1 | X | CWHC
2/26/2009 0:00 | MABS001 | 2009-10-04 00:00:00 | 4/17/2009 | CWHC | 1 | X | CWHC
2/26/2009 15:35 | MABS001 | 2009-10-04 00:00:00 | 4/17/2009 | CWHC | -1 | X | CWHC
2/27/2009 0:00 | IDDB001 | 2009-11-04 00:00:00 | 4/18/2009 | CWHC | 1 | X | CWHC
2009-09-04 00:00:00 | THOJ033 | 4/19/2009 | 4/28/2009 | CWHC | 1 | X | CWHC
4/21/2009 15:32 | THOJ033 | 4/19/2009 | 4/28/2009 | CWHC | -1 | X | CWHC
4/20/2009 0:00 | CUNJ004 | 4/25/2009 | 2009-02-05 00:00:00 | CWHC | 1 | X | CWHC
4/28/2009 12:17 | CUNJ004 | 4/25/2009 | 2009-02-05 00:00:00 | CWHC | -1 | X | CWHC
3/19/2009 0:00 | BROL013 | 2009-01-05 00:00:00 | 2009-06-05 00:00:00 | CWHC | 1 | X | CWHC
3/19/2009 15:46 | BROL013 | 2009-01-05 00:00:00 | 2009-06-05 00:00:00 | CWHC | -1 | X | CWHC
3/19/2009 0:00 | BROL013 | 2009-01-05 00:00:00 | 2009-06-05 00:00:00 | CWHC | 1 | X | CWHC
3/19/2009 15:47 | BROL013 | 2009-01-05 00:00:00 | 2009-06-05 00:00:00 | CWHC | -1 | X | CWHC
12/30/2008 0:00 | AITB001 | 2009-02-05 00:00:00 | 2009-09-05 00:00:00 | CWHC | 1 | X | CWHC
6/17/2009 15:02 | AITB001 | 2009-02-05 00:00:00 | 2009-09-05 00:00:00 | CWHC | -1 | X | CWHC
2009-07-05 00:00:00 | HURE003 | 2009-08-05 00:00:00 | 5/15/2009 | CWHC | 1 | X | CWHC
2009-08-05 15:18:00 | HURE003 | 2009-08-05 00:00:00 | 5/15/2009 | CWHC | -1 | X | CWHC
2009-03-02 00:00:00 | CLAL006 | 2009-09-05 00:00:00 | 5/16/2009 | CWHC | 1 | X | CWHC
2009-03-02 12:54:00 | CLAL006 | 2009-09-05 00:00:00 | 5/16/2009 | CWHC | -1 | X | CWHC
2/13/2009 0:00 | CLAL006 | 2009-09-05 00:00:00 | 5/16/2009 | CWHC | 1 | X | CWHC
2/13/2009 11:54 | CLAL006 | 2009-09-05 00:00:00 | 5/16/2009 | CWHC | -1 | X | CWHC
2/13/2009 11:54 | CLAL006 | 2009-09-05 00:00:00 | 5/16/2009 | CWHC | 1 | X | CWHC
2/16/2009 9:37 | CLAL006 | 2009-09-05 00:00:00 | 5/16/2009 | CWHC | -1 | X | CWHC
2009-06-04 00:00:00 | CLAA013 | 5/15/2009 | 5/22/2009 | CWHC | 1 | X | CWHC
2009-07-04 17:36:00 | CLAA013 | 5/15/2009 | 5/22/2009 | CWHC | -1 | X | CWHC
2009-07-04 00:00:00 | CLAA013 | 5/15/2009 | 5/22/2009 | CWHC | 1 | X | CWHC
2009-07-04 17:38:00 | CLAA013 | 5/15/2009 | 5/22/2009 | CWHC | -1 | X | CWHC
2009-07-04 00:00:00 | CLAA013 | 5/15/2009 | 5/22/2009 | CWHC | 1 | X | CWHC
4/21/2009 9:27 | CLAA013 | 5/15/2009 | 5/22/2009 | CWHC | -1 | X | CWHC
4/21/2009 0:00 | CLAA013 | 5/15/2009 | 5/22/2009 | CWHC | 1 | X | CWHC