<?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 Date Time Conversions in Archive</title>
    <link>https://business.forums.bt.com/t5/Archive/Date-Time-Conversions/m-p/55998#M15053</link>
    <description>&lt;P&gt;I'm trying to convert my date and time to a better format so I can compare it to a time and date 36 hours from now. Then I plan to compare these two so I can see which date is earlier.&lt;BR /&gt;&lt;BR /&gt;My problem is that I can't just use the typical methods because the code is mixing my day and month.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;$orig= $v_CurrentRecordD['day'].",  ".$v_CurrentRecordD['time']; //MM/DD/YYYY, HH:MM
$conv = date('m/d/Y H:i', strtotime($orig));
$daycutoff = date('m/d/Y H:i', strtotime("+36 hours"));
echo $orig."-".$conv."-".$daycutoff." &amp;lt;br /&amp;gt;";  


Output 
06-20-2013, 8:00am-12/31/1969 18:00-06/05/2013 22:56
02-11-2013, 8:45am-11/02/2013 08:45-06/05/2013 22:56
02-11-2013, 8:15am-11/02/2013 08:15-06/05/2013 22:56
02-11-2013, 8:00am-11/02/2013 08:00-06/05/2013 22:56
06-01-2012, 10:15am-01/06/2012 10:15-06/05/2013 22:56
02-11-2013, 8:30am-11/02/2013 08:30-06/05/2013 22:56
02-12-2013, 10:45am-12/02/2013 10:45-06/05/2013 22:56
02-12-2013, 10:30am-12/02/2013 10:30-06/05/2013 22:56 &lt;/PRE&gt;&lt;P&gt;&amp;nbsp;Any help?&lt;/P&gt;&lt;DIV&gt;&lt;IMG src="http://imagicon.info/cat/12-1/1.gif" /&gt;&lt;/DIV&gt;</description>
    <pubDate>Tue, 04 Jun 2013 17:50:55 GMT</pubDate>
    <dc:creator>abirhasan</dc:creator>
    <dc:date>2013-06-04T17:50:55Z</dc:date>
    <item>
      <title>Date Time Conversions</title>
      <link>https://business.forums.bt.com/t5/Archive/Date-Time-Conversions/m-p/55998#M15053</link>
      <description>&lt;P&gt;I'm trying to convert my date and time to a better format so I can compare it to a time and date 36 hours from now. Then I plan to compare these two so I can see which date is earlier.&lt;BR /&gt;&lt;BR /&gt;My problem is that I can't just use the typical methods because the code is mixing my day and month.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;$orig= $v_CurrentRecordD['day'].",  ".$v_CurrentRecordD['time']; //MM/DD/YYYY, HH:MM
$conv = date('m/d/Y H:i', strtotime($orig));
$daycutoff = date('m/d/Y H:i', strtotime("+36 hours"));
echo $orig."-".$conv."-".$daycutoff." &amp;lt;br /&amp;gt;";  


Output 
06-20-2013, 8:00am-12/31/1969 18:00-06/05/2013 22:56
02-11-2013, 8:45am-11/02/2013 08:45-06/05/2013 22:56
02-11-2013, 8:15am-11/02/2013 08:15-06/05/2013 22:56
02-11-2013, 8:00am-11/02/2013 08:00-06/05/2013 22:56
06-01-2012, 10:15am-01/06/2012 10:15-06/05/2013 22:56
02-11-2013, 8:30am-11/02/2013 08:30-06/05/2013 22:56
02-12-2013, 10:45am-12/02/2013 10:45-06/05/2013 22:56
02-12-2013, 10:30am-12/02/2013 10:30-06/05/2013 22:56 &lt;/PRE&gt;&lt;P&gt;&amp;nbsp;Any help?&lt;/P&gt;&lt;DIV&gt;&lt;IMG src="http://imagicon.info/cat/12-1/1.gif" /&gt;&lt;/DIV&gt;</description>
      <pubDate>Tue, 04 Jun 2013 17:50:55 GMT</pubDate>
      <guid>https://business.forums.bt.com/t5/Archive/Date-Time-Conversions/m-p/55998#M15053</guid>
      <dc:creator>abirhasan</dc:creator>
      <dc:date>2013-06-04T17:50:55Z</dc:date>
    </item>
  </channel>
</rss>

