Spreadsheet: 205422d1357812465-date-problem-alan-renewal-listing
Sheet: ILP Renewal 2013

 |  | ILP RENEWAL LISTING 2013
 | No. | Customer Name | Policy No. | Policy Date | Mode | Payment | Premium | Trade In |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Remark
 | 1 | [NAME] | 8528808A | 2009-04-14 00:00:00 | Yearly | D.Payment | 1500
 | 2 | [NAME] | 8529031A | 2009-05-11 00:00:00 | Monthly | D.Payment | 2400
 | 3 | Ng Min Jin | 8529414A | 2009-08-03 00:00:00 | Yearly | C.Card | 1800 |  |  | O | O | O | O | O | O | O
 | 4 | [NAME] | 8530180A | 2009-10-19 00:00:00 | Monthly | C.Card | 1500
 | 5 | [NAME] | 8520184A | 2009-10-19 00:00:00 | Monthly | D.Payment | 1920
 | 6 | [NAME]. [NAME] | 8530270A | 2009-12-03 00:00:00 | Monthly | C.Card | 1500
 | 7 | [NAME] | 8531655A | 2010-02-24 00:00:00 | Yearly | D.Payment | 1800 |  |  | O
 | 8 | [NAME] | 8531666A | 2010-02-24 00:00:00 | Yearly | D.Payment | 1800 |  |  | O
 | 9 | [NAME] | 8532400A | 2010-04-19 00:00:00 | Yearly | C.Card | 3230 |  |  | O | O | O
 | 10 | Chong Wai Khen | 8532797A | 2010-06-21 00:00:00 | Monthly | C.Card | 2000
 | 11 | [NAME] | 8533489A | 2010-09-13 00:00:00 | Yearly | D.Payment | 1500 |  |  | O | O | O | O | O | O | O | O
 | 12 | [NAME] | 8533497A | 2010-10-06 00:00:00 | Monthly | C.Card | 1550
 | 13 | [NAME] | 8534259A | 2010-11-08 00:00:00 | Monthly | D.Payment | 1800
 | 14 | Soo Soon Keat | 8534454A | 2010-11-28 00:00:00 | Monthly | D.Payment | 1800
 | 15 | [NAME] | 8534528A | 2011-01-06 00:00:00 | Monthly | D.Payment | 2700
 | 16 | Low [NAME] | 8534549A | 2011-02-08 00:00:00 | Monthly | D.Payment | 1800
 | 17 | Ivy [NAME] | 8534745A | 2011-02-28 00:00:00 | Monthly | C.Card | 3000
 | 18 | Lim Chai Huay | 8535003A | 2011-02-28 00:00:00 | Monthly | C.Card | 1950
 | 19 | [NAME] | 8535178A | 2011-03-28 00:00:00 | Monthly | C.Card | 1800
 | 20 | [NAME] | 8704631A | 2011-03-28 00:00:00 | Monthly | C.Card | 2400
 | 21 | [NAME] | 8704639A | 2011-03-28 00:00:00 | Monthly | C.Card | 3000
 | 22 | [NAME] | 8710005A | 2011-04-19 00:00:00 | Monthly | C.Card | 1500
 | 23 | How [NAME] | 8710235A | 2011-05-16 00:00:00 | Monthly | D.Payment | 2400
 | 24 | [NAME] | 8722704A | 2011-06-20 00:00:00 | Monthly | C.Card | 2640
 | 25 | [NAME] | 8722876A | 2011-07-06 00:00:00 | Monthly | C.Card | 3000
 | 26 | [NAME] | 8723184A | 2011-08-22 00:00:00 | Yearly | D.Payment | 2220 | 5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-07-22 00:00:00
 | 27 | Ng [NAME] | 8723189A | 2011-08-24 00:00:00 | Yearly | D.Payment | 6620
 | 28 | [NAME] | 8739522A | 2011-09-26 00:00:00 | Monthly | C.Card | 1560
 | 29 | [NAME] | 8739703A | 2011-09-28 00:00:00 | Monthly | C.Card | 2400
 | 30 | [NAME] | 8739523A | 2011-09-28 00:00:00 | Monthly | C.Card | 1560
 | 31 | [NAME] | 8739909A | 2011-10-28 00:00:00 | Yearly | C.Card | 2700 |  |  | O | O | O | O | O | O | O | O | O
 | 32 | [NAME] | 8740076A | 2011-11-16 00:00:00 | Monthly | C.Card | 3000
 | 33 | [NAME] | 8758571A | 2012-02-13 00:00:00 | Top Up | D.Payment | 3600
 | 34 | Hong Keng Boey | 8758631A | 2012-02-24 00:00:00 | Top Up | D.Payment | 3000
 | 35 | Chong Wai Lim | 8758929A | 2012-04-09 00:00:00 | Monthly | C.Card | 2400
 | 36 | [NAME] | 8968461A | 2012-05-07 00:00:00 | Monthly | C.Card | 1860
 | 37 | [NAME] | 8968638A | 2012-06-07 00:00:00 | Yearly | C.Card | 1944 |  |  | O | O | O | O | O |  |  |  |  |  |  |  |  | 2013-05-07 00:00:00
 | 38 | [NAME] | 8969039A | 2012-06-28 00:00:00 | Monthly | D.Payment | 2100
 | 39 | Chong Chee Ning | 8969239A | 2012-08-09 00:00:00 | Monthly | D.Payment | 1500
 | 40 | [NAME] | 51002799 | 2012-09-11 00:00:00 | Monthly | C.Card | 2100
 | 41 | Soo [NAME] | 51003077 | 2012-09-13 00:00:00 | Monthly | D.Payment | 1920
 | 42 | [NAME] | 51004064 | 2012-09-27 00:00:00 | Yearly | C.Card | 2400 | 3000 |  | O | O | O | O | O | O | O | O |  |  |  |  |  | 2013-08-27 00:00:00
 | 43 | [NAME] | 51004659 | 2012-10-08 00:00:00 | Yearly | C.Card | 2400 | 8000 |  | O | O | O | O | O | O | O | O | O |  |  |  |  | 2013-09-08 00:00:00
 | 44 | [NAME] | 51004660 | 2012-10-08 00:00:00 | Yearly | C.Card | 3000 |  |  | O | O | O | O | O | O | O | O | O |  |  |  |  | 2013-09-08 00:00:00
 | 45 | [NAME] | 51005234 | 2012-10-09 00:00:00 | Yearly | C.Card | 2100 |  |  | O | O | O | O | O | O | O | O | O |  |  |  |  | 2013-09-09 00:00:00
 | 46 | [NAME] | 51006471 | 2012-10-24 00:00:00 | Monthly | C.Card | 1800
 | 47 | [NAME] | 51006614 | 2012-10-25 00:00:00 | Yearly | D.Payment | 2400 |  |  | O | O | O | O | O | O | O | O | O