<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>‏‎‎‍‎‏‍‌‍‍‏‏
‎‌‌‎‌‏‌‎‎‍‍‎‎
‍‍‎‌‌‏‏‎‎‍‍‌‌
‍‌‌‍‍‏‎‎‏‌‌‍‍
‌‌‎‎‍‎‏‌‎‎‌‌
‌‏‏‍‌‌‍‏‏‎‎‍‍
‏‌‏‏‍‍‏‌‌‍‌‍‌
‌‎‍‍‏‍‌‎‎‏‌‏‏
‎‌‍‏‏‍‌‎‏‏‍‍‎
‌‌‍‎‎‏‌‏‏‌‍‍‌
‌‍‌‌‍‍‎‎‌‌‍‍
‌‌‏‏‎‎‌‌‎‎‏‌‌
‏‎‌‌‎‎‍‍‏‏‎‎‍
‌‌‎‌‌‍‏‎‍‎‎‌
‍‍‏‎‏‏‍‍‎‌‌‏‏
‎‌‏‏‍‎‍‍‎‎‍‍‏
‍‎‏‍‍‎‎‍‍‌‌‏‌
‍‍‎‎‍‌‌‏‏‎‎‌‎
‎‎‍‍‎‏‍‎‍‌‍‍‎
‎‎‍‍‎‏‏‎‏‌‏‏‍‍
‏‏‍‍‌‌‏‎‎‌‎‍‍
‎‌‏‏‍‍‌‌‎‏‍‎‏
‍‏‎‎‍‍‌‎‌‎‎‏‏
‎‎‏‏‌‏‎‏‏‎‍‍‏
‏‏‌‏‌‍‎‎‌‌‎‎‏
‌‍‍‌‍‎‎‍‏‏‎‌‌
‍‍‌‏‍‌‍‍‌‎‎‏‍
‏‏‍‍‌‌‏‎‍‍‎‎‏
‎‎‌‌‍‏‏‎‍‏‍‍‌
‌‌‎‌‌‎‎‏‏‍‍‏‏
‏‎‎‍‏‌‌‎‍‎‎‏‎
‍‏‎‍‍‎‍‌‎‍‎‌‌
‏‍‎‌‌‎‎‍‌‌‎‏‏
‌‍‍‏‏‍‍‎‎‏‏‍‍
‎‎‍‍‌‌‏‎‍‍‌‌‏
‌‌‍‌‌‍‏‏‍‍‎‎‌
‍‍‌‏‌‎‏‎‎‍‍‎‍
‌‌‏‏‌‍‍‎‎‏‏‍‎
‎‎‏‌‌‏‏‌‌‍‏‍‌
‍‌‌‎‎‍‌‍‍‌‍‎‎
‏‎‎‌‌‍‍‎‎‏‏‎‏
‌‌‏‏‌‍‍‏‍‍‎‎‍
‌‌‍‍‎‎‌‌‍‌‌‎‎
‎‍‍‌‍‍‎‍‍‏‍‎‏‏
‍‏‎‍‎‎‍‎‎‏‎‍‌
‏‌‎‎‌‌‍‍‏‍‌‌
‌‏‏‌‌‎‎‍‌‌‎‌
‌‍‌‍‏‏‌‌‎‎‍‏‏
‎‌‌‍‍‏‎‌‍‌‍‍‌
‏‏‎‎‏‌‌‏‍‎‎‌‌
‎‎‍‍‏‏‍‎‌‌‍‏‏
‍‏‌‌‍‍‎‎‌‌‎‍‍
‌‌‍‍‎‌‏‍‎‎‌‌
‎‍‏‎‏‍‏‎‏‏‎‍‍
‏‏‍‎‌‎‎‏‌‌‍‌‌
‏‍‎‌‏‍‏‌‎‌‍‍‏
‏‏‌‌‎‎‌‌‎‎‌‎
‌‏‍‍‎‍‌‌‎‎‍‎‏
Is it possible to change the date to something easier to read?</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.apple-style-span
{mso-style-name:apple-style-span;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hmmm… Since you're happy with the Long Date format, I'm
*guessing* there's no need for you to add a Custom Format on the date-time
configure page. Just chose which Long Date format makes the most sense. But, that’s
just a guess.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I had to do this recently for the first time myself - creating a
custom date/time for a View. I guess I'll just tell you what I did for my View;
I needed it to show an <i><u>hour</u></i> , in a format that would make sense
to US based users (e.g. <b>5:52a</b>).<br>
<br>
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Here's what I did… <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Under "</span><span class=apple-style-span><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:#1F497D'>Add
format type" on the date/time configure page I typed:</span></span><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><br>
<br>
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>-------<br>
Name: Hour Stamp<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Type: hour_stamp<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>------<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I just chose "names" that made sense to me and my
audience. (Again, I'm not sure you need to create a custom format..)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><br>
for the "</span><span class=apple-style-span><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:#1F497D'>Format string"</span></span><span
class=apple-style-span><b><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:#494949'> </span></b></span><span style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'>I looked at the php manual (Drupal shows
a link to it) and found what I needed to just show the hour in a familiar US
format.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Next I went over to my <i><u>View</u></i>, and under "Fields"
I chose <i>"</i></span><span class=apple-style-span><i><span
style='font-size:9.0pt;font-family:"Verdana","sans-serif";color:#1F497D'>Content:
Date (field_date) - From date"</span></i></span><span
class=apple-style-span><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:#1F497D'> <o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:#1F497D'><o:p> </o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:#1F497D'>Next I chose: <i>"Link
this field to its node"</i> (personal preference)<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:#1F497D'><o:p> </o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:#1F497D'>And for "Format" I chose:
<i>"Hour Stamp</i>" (see if you can choose "Long" here).<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:#1F497D'><o:p> </o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:#1F497D'><o:p> </o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:9.0pt;
font-family:"Verdana","sans-serif";color:#1F497D'>That’s what I needed to
do for my situation. I don’t know if that will help or not, but
hopefully it points you in the right direction!</span></span><span
class=apple-style-span><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:#494949'><br>
<br>
</span></span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>------<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#404040'>brendan, fresh-off.com<o:p></o:p></span></b></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#404040'>Creative Direction & Consultation: Web | Print | Brand<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#404040'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#404040'><a href="http://fresh-off.com">http://fresh-off.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#404040'><a href="mailto:hello@fresh-off.com">hello@fresh-off.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#404040'>206.328.1067<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><br>
<br>
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Tine Müller
[mailto:tinem@email.dk] <br>
<b>Sent:</b> Thursday, October 15, 2009 10:18 PM<br>
<b>To:</b> brendan, fresh-off.com<br>
<b>Subject:</b> Re: [support] Is it possible to change the date to something
easier to read?<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Thanks
for trying to help but I don't know what to do? If I for instance want the Long
date format: what shall I then write in the box Name: and the box Type:?</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>/Tine</span><o:p></o:p></p>
</div>
</div>
<blockquote style='border:none;border-left:solid black 1.5pt;padding:0in 0in 0in 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>-----
Original Message ----- <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='background:#E4E4E4'><b><span style='font-size:10.0pt;
font-family:"Arial","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Arial","sans-serif"'> <a href="mailto:hello@fresh-off.com"
title="hello@fresh-off.com">brendan, fresh-off.com</a> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>To:</span></b><span
style='font-size:10.0pt;font-family:"Arial","sans-serif"'> <a
href="mailto:support@drupal.org" title="support@drupal.org">support@drupal.org</a>
; <a href="mailto:tinem@email.dk" title="tinem@email.dk">'Tine Müller'</a> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Sent:</span></b><span
style='font-size:10.0pt;font-family:"Arial","sans-serif"'> Thursday, October
15, 2009 10:37 PM<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Subject:</span></b><span
style='font-size:10.0pt;font-family:"Arial","sans-serif"'> RE: [support] Is it
possible to change the date to something easier to read?<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>this might be what you're looking for: <a
href="http://www.tinemuller.dk/drupal/admin/settings/date-time/formats/configure">http://www.tinemuller.dk/drupal/admin/settings/date-time/formats/configure</a>
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>------<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#404040'>brendan, fresh-off.com<o:p></o:p></span></b></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#404040'>Creative Direction & Consultation: Web | Print | Brand<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#404040'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#404040'><a href="http://fresh-off.com">http://fresh-off.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#404040'><a href="mailto:hello@fresh-off.com">hello@fresh-off.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#404040'>206.328.1067<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> <a
href="mailto:support-bounces@drupal.org">support-bounces@drupal.org</a>
[mailto:support-bounces@drupal.org] <b>On Behalf Of </b>Tine Müller<br>
<b>Sent:</b> Thursday, October 15, 2009 8:06 AM<br>
<b>To:</b> support@drupal.org<br>
<b>Subject:</b> [support] Is it possible to change the date to something easier
to read?<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal>Is it possible to change the date to something easier to
read and if yes where? Should it be in excel, phpmyadmin or Content type field
date?<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><a href="http://www.tinemuller.dk/drupal/Crime">http://www.tinemuller.dk/drupal/Crime</a> look
in InfoWindow Date: 20070328T07:03:00. <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>It's
made from this CSV-file <a href="http://www.tinemuller.dk/drupal/crime_data.csv">http://www.tinemuller.dk/drupal/crime_data.csv</a> and
from this tutorial <a
href="http://zacker.org/screencast-drupal-mashup-machine#comment-3556">http://zacker.org/screencast-drupal-mashup-machine#comment-3556</a></span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>M.v.h.<br>
Tine Müller<br>
<br>
<a href="http://tine_muller.homepage.dk/">http://tine_muller.homepage.dk/</a><br>
<a href="http://www.findbiblioteket.dk/">http://www.findbiblioteket.dk/</a></span><o:p></o:p></p>
</div>
<div><pre> <o:p></o:p></pre><pre><o:p> </o:p></pre><pre><br>
<br>
<o:p></o:p></pre><pre><img border=0 width=3 height=1 id="_x0000_i1025"
src="http://www.jqkt4b2xwhj198.ReadNotify.com/nocache/jqkt4b2xwhj199/footer0.gif"
alt=0><b>Error! Filename not specified.</b><o:p></o:p></pre></div>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=2 width="100%" align=center>
</div>
<p class=MsoNormal><br>
No virus found in this incoming message.<br>
Checked by AVG - www.avg.com <br>
Version: 8.5.421 / Virus Database: 270.14.18/2437 - Release Date: 10/15/09
03:57:00<o:p></o:p></p>
</blockquote>
<div><pre> <o:p></o:p></pre><pre><o:p> </o:p></pre><pre><br>
<img border=0 width=3 height=1 id="_x0000_i1027"
src="http://www.kj6vxskfssmle8.ReadNotify.com/nocache/kj6vxskfssmle9/footer0.gif"
alt=0><b>Error! Filename not specified.</b><o:p></o:p></pre></div>
</div>
</body>
</html>