<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: calculate the days between two dates in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/calculate-the-days-between-two-dates/m-p/129310#M90857</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;CODE&gt;&lt;BR /&gt;(DateFormType) execution.getVariable("dateFrom")&lt;BR /&gt;&lt;/CODE&gt;&lt;BR /&gt;&lt;SPAN&gt;This does not work… When submitting a form-property of type "date", a java.util.Date instance is stored as variable. You can compare them as you would compare any other date…&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 04 Feb 2013 09:09:23 GMT</pubDate>
    <dc:creator>frederikherema1</dc:creator>
    <dc:date>2013-02-04T09:09:23Z</dc:date>
    <item>
      <title>calculate the days between two dates</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/calculate-the-days-between-two-dates/m-p/129309#M90856</link>
      <description>Hello,I want to calculate the days between two dates.But I don't know how to do this.Right now I tried it with:.bpmn20.xml&amp;lt;activiti:formProperty id="dateFrom" name="Date from (dd-MM-yyyy)" datePattern="dd-MM-yyyy hh:mm" type="date"&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;required="true" /&amp;gt;&amp;lt;activiti:formProperty id="dat</description>
      <pubDate>Sun, 03 Feb 2013 15:22:32 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/calculate-the-days-between-two-dates/m-p/129309#M90856</guid>
      <dc:creator>tomi87</dc:creator>
      <dc:date>2013-02-03T15:22:32Z</dc:date>
    </item>
    <item>
      <title>Re: calculate the days between two dates</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/calculate-the-days-between-two-dates/m-p/129310#M90857</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;CODE&gt;&lt;BR /&gt;(DateFormType) execution.getVariable("dateFrom")&lt;BR /&gt;&lt;/CODE&gt;&lt;BR /&gt;&lt;SPAN&gt;This does not work… When submitting a form-property of type "date", a java.util.Date instance is stored as variable. You can compare them as you would compare any other date…&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 04 Feb 2013 09:09:23 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/calculate-the-days-between-two-dates/m-p/129310#M90857</guid>
      <dc:creator>frederikherema1</dc:creator>
      <dc:date>2013-02-04T09:09:23Z</dc:date>
    </item>
    <item>
      <title>Re: calculate the days between two dates</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/calculate-the-days-between-two-dates/m-p/129311#M90858</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Ok I got it now.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Thank you!&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;CODE&gt;import java.io.Serializable;&lt;BR /&gt;import java.text.SimpleDateFormat;&lt;BR /&gt;import java.util.Calendar;&lt;BR /&gt;import java.util.Date;&lt;BR /&gt;import java.util.GregorianCalendar;&lt;BR /&gt;import java.util.Locale;&lt;BR /&gt;import java.util.regex.Pattern;&lt;BR /&gt;&lt;BR /&gt;import org.activiti.engine.impl.form.DateFormType;&lt;BR /&gt;&lt;BR /&gt;public class StapIn implements Serializable {&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; DateFormType dft = new DateFormType("dd-MM-yyyy");&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; private String dateFrom;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; private String dateTo;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; private long days;&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; public void setDateFrom(Date dateType) {&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; this.dateFrom = dft.convertModelValueToFormValue(dateType);&lt;BR /&gt;&amp;nbsp;&amp;nbsp; }&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; // for testing change DateFormType into Date&lt;BR /&gt;&amp;nbsp;&amp;nbsp; public void setDateTo(Date dateType) {&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; this.dateTo = dft.convertModelValueToFormValue(dateType);&lt;BR /&gt;&amp;nbsp;&amp;nbsp; }&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; public void setDays(long days) {&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; this.days = days;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; }&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; public long getDays() {&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Calendar gcFrom = new GregorianCalendar();&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Calendar gcTo = new GregorianCalendar();&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; String dateFrom = getDateFrom();&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; String dateTo = getDateTo();&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Date ddFrom = (Date) dft.convertFormValueToModelValue(dateFrom);&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Date ddto = (Date) dft.convertFormValueToModelValue(dateTo);&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; gcFrom.setTime(ddFrom);&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; gcTo.setTime(ddto);&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; long time = gcTo.getTime().getTime() - gcFrom.getTime().getTime();&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; long day = Math.round((double) time / (24. * 60. * 60. * 1000.));&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; setDays(day);&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; return days;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; }&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; public String getDateFrom() {&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; return dateFrom;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; }&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; public String getDateTo() {&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; return dateTo;&lt;BR /&gt;&amp;nbsp;&amp;nbsp; }&lt;BR /&gt;}&lt;/CODE&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 04 Feb 2013 11:39:32 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/calculate-the-days-between-two-dates/m-p/129311#M90858</guid>
      <dc:creator>tomi87</dc:creator>
      <dc:date>2013-02-04T11:39:32Z</dc:date>
    </item>
  </channel>
</rss>

