I created a procedure to test how dates are displayed when I start with a format of mm/dd/yyyy and use 'reformat'. Here is the code:
Code: Select all
echo "date format when using reformat";
echo "<br>\n";
print "from date without reformat is ".'#vFrom#';
echo "<br>\n";
$fromdate = reformatField('#vFrom#', 6);
print "from date with reformat 6 is ".$fromdate;
echo "<br>\n";
$fromdate = reformatField('#vFrom#', 7);
print "from date with reformat 7 is ".$fromdate;
echo "<br>\n";
$fromdate = reformatField('#vFrom#', 8);
print "from date with reformat 8 is ".$fromdate;
echo "<br>\n";
$fromdate = reformatField('#vFrom#', 9);
print "from date with reformat 9 is ".$fromdate;
echo "<br>\n";
$fromdate = reformatField('#vFrom#', 10);
print "from date with reformat 10 is ".$fromdate;
echo "<br>\n";
$fromdate = reformatField('#vFrom#', 11);
print "from date with reformat 11 is ".$fromdate;
echo "<br>\n";
$fromdate = reformatField('#vFrom#', 12);
print "from date with reformat 12 is ".$fromdate;
echo "<br>\n";
$fromdate = reformatField('#vFrom#', 13);
print "from date with reformat 13 is ".$fromdate;
echo "<br>\n";
When I run the same procedure on the web site, I get the following:date format when using reformat
from date without reformat is 01-16-2013
from date with reformat 6 is '2013--01'
from date with reformat 7 is '2013-16-01'
from date with reformat 8 is '2013--6-'
from date with reformat 9 is '2013-01-16'
from date with reformat 10 is '2013--01'
from date with reformat 11 is '2013-16-01'
from date with reformat 12 is '2013--6-'
from date with reformat 13 is '2013-01-16'
At first I thought it was a problem with magic quotes on the web site so I turned magic quotes off and verified that they are off:date format when using reformat
from date without reformat is
from date with reformat 6 is NULL
from date with reformat 7 is NULL
from date with reformat 8 is NULL
from date with reformat 9 is NULL
from date with reformat 10 is NULL
from date with reformat 11 is NULL
from date with reformat 12 is NULL
from date with reformat 13 is NULL
Is there another place where the date format could be affected on the web site?[magic_quotes_gpc] => Array
(
[global_value] =>
[local_value] =>
[access] => 6
)
[magic_quotes_runtime] => Array
(
[global_value] =>
[local_value] =>
[access] => 7
)
[magic_quotes_sybase] => Array
(
[global_value] =>
[local_value] =>
[access] => 7
)
Thanks,
John