1 /*
2 * ObjectLab, http://www.objectlab.co.uk/open is sponsoring the ObjectLab Kit.
3 *
4 * Based in London, we are world leaders in the design and development
5 * of bespoke applications for the securities financing markets.
6 *
7 * <a href="http://www.objectlab.co.uk/open">Click here to learn more</a>
8 * ___ _ _ _ _ _
9 * / _ \| |__ (_) ___ ___| |_| | __ _| |__
10 * | | | | '_ \| |/ _ \/ __| __| | / _` | '_ \
11 * | |_| | |_) | | __/ (__| |_| |__| (_| | |_) |
12 * \___/|_.__// |\___|\___|\__|_____\__,_|_.__/
13 * |__/
14 *
15 * www.ObjectLab.co.uk
16 *
17 * $Id$
18 *
19 * Copyright 2006 the original author or authors.
20 *
21 * Licensed under the Apache License, Version 2.0 (the "License"); you may not
22 * use this file except in compliance with the License. You may obtain a copy of
23 * the License at
24 *
25 * http://www.apache.org/licenses/LICENSE-2.0
26 *
27 * Unless required by applicable law or agreed to in writing, software
28 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
29 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
30 * License for the specific language governing permissions and limitations under
31 * the License.
32 */
33 package net.objectlab.kit.datecalc.joda;
34
35 import java.util.Calendar;
36
37 import net.objectlab.kit.datecalc.common.ExcelDateUtil;
38
39 import org.joda.time.DateTime;
40 import org.joda.time.LocalDate;
41
42 /**
43 * Convert Excel Date to LocalDate, YearMonthDay or DateTime.
44 *
45 * @author Benoit Xhenseval
46 *
47 */
48 public final class JodaExcelDateUtil {
49
50 private JodaExcelDateUtil() {
51 }
52
53 public static LocalDate getLocalDate(final double date, final boolean use1904windowing) {
54 final Calendar c = ExcelDateUtil.getJavaCalendar(date, use1904windowing);
55
56 if (c == null) {
57 return null;
58 }
59
60 return new LocalDate().withYear(c.get(Calendar.YEAR)).withMonthOfYear(c.get(Calendar.MONTH) + 1).withDayOfMonth(c.get(Calendar.DAY_OF_MONTH));
61 }
62
63 // -----------------------------------------------------------------------
64 //
65 // ObjectLab, world leaders in the design and development of bespoke
66 // applications for the securities financing markets.
67 // www.ObjectLab.co.uk
68 //
69 // -----------------------------------------------------------------------
70
71 public static DateTime getDateTime(final double date, final boolean use1904windowing) {
72 final Calendar c = ExcelDateUtil.getJavaCalendar(date, use1904windowing);
73
74 if (c == null) {
75 return null;
76 }
77
78 return new DateTime().withYear(c.get(Calendar.YEAR)).withMonthOfYear(c.get(Calendar.MONTH) + 1).withDayOfMonth(c.get(Calendar.DAY_OF_MONTH))
79 .withMillisOfDay(0);
80 }
81 }
82
83 /*
84 * ObjectLab, http://www.objectlab.co.uk/open is sponsoring the ObjectLab Kit.
85 *
86 * Based in London, we are world leaders in the design and development
87 * of bespoke applications for the securities financing markets.
88 *
89 * <a href="http://www.objectlab.co.uk/open">Click here to learn more about us</a>
90 * ___ _ _ _ _ _
91 * / _ \| |__ (_) ___ ___| |_| | __ _| |__
92 * | | | | '_ \| |/ _ \/ __| __| | / _` | '_ \
93 * | |_| | |_) | | __/ (__| |_| |__| (_| | |_) |
94 * \___/|_.__// |\___|\___|\__|_____\__,_|_.__/
95 * |__/
96 *
97 * www.ObjectLab.co.uk
98 */