HTML Date Format

[kingcarol]

Hopefully this is a simple question. I tried searching for HTML Date format but get stuff I don't need.
If you look at this edit combo drop down field, you can see that my dates are including the time and I don't want that: http://screencast.com/t/mAEtZHtN

Here's the display template for that edit combo lookup. What would you do to format the GL_DATE as a date like 10/14/2011 ?

<!--TitleSectionStart-->
<table>
<tr>
<td style="width: 1in; font-weight: bold;">Dep Date</td>
<td style="width: 1in; font-weight: bold;">Deposit ID</td>
</tr>
</table>
<!--TitleSectionEnd-->
<!--BodySectionStart-->
<table>
<tr>
<td style="width: 1in;">{GL_DATE}</td>
<td style="width: 1in;">{GL_DOCUMENT}</td>
</tr>
</table>
<!--BodySectionEnd-->

[kingcarol]

Re: HTML Date Format

bump .... anyone? anyone?

[Lance Gurd]

Re: HTML Date Format

Hi Carol,

just tried to recreate and my SQL date fields are obviously with the time element, created a lookup on the date in the search and I just get the date part.

In properties for the grid I have set (under miscellaneous) date format to dd/mm/yyyy (being from the UK), you could set it to mm/dd/yyyy and hopefully that will work

[kingcarol]

Re: HTML Date Format

Thanks, Lance. I already have that set in the properties as mm/dd/yy and in all time pickers for fields. I think my problem could be that the lookup is not really for the date, and returns the GL_DOCUMENT. I wanted to list the GL_DOCUMENT in descending date order so the most recent GL_DOCUMENTs would be at the top of the list. So maybe it's not picking up the formattting? So, still wondering what the HTML code is to format a date so I could hard code it in. Like, how would you format a date if you just read a date on a web page and display it?

[kingcarol]

Re: HTML Date Format

Maybe it's not possible to format a date with html code?

[Lance Gurd]

Re: HTML Date Format

sorry Carol, not been able to find anything except that in HTML5 there are new date and time tags http://www.w3schools.com/html5/tag_time.asp

[aal_fareed]

Re: HTML Date Format

hi carol ... did you manage to resolve this issue ?
i am having the same problem .
spent 3 hours and i cannot find somethign helps me >.< this shoud be so simple duh !

[MarionT]

Re: HTML Date Format

Let your database do the work...
for eg, in SQL:


select
getdate() as UnconvertedDateTime
,cast(getDate() as nvarchar(30)) as UsingCast
,Convert(nvarchar(30), getdate(),101) as UsingConvertTo101
,Convert(nvarchar(30), getdate(),102) as UsingConvertTo102
,Convert(nvarchar(30), getdate(),103) as UsingConvertTo103
,Convert(nvarchar(30), getdate(),104) as UsingConvertTo104
,Convert(nvarchar(30), getdate(),107) as UsingConvertTo107

The one you want is: Convert(nvarchar(30), getdate(),101) as UsingConvertTo101

The others are shown for demonstration purposes

[aal_fareed]

Re: HTML Date Format

Let your database do the work...
for eg, in SQL:


select
getdate() as UnconvertedDateTime
,cast(getDate() as nvarchar(30)) as UsingCast
,Convert(nvarchar(30), getdate(),101) as UsingConvertTo101
,Convert(nvarchar(30), getdate(),102) as UsingConvertTo102
,Convert(nvarchar(30), getdate(),103) as UsingConvertTo103
,Convert(nvarchar(30), getdate(),104) as UsingConvertTo104
,Convert(nvarchar(30), getdate(),107) as UsingConvertTo107

The one you want is: Convert(nvarchar(30), getdate(),101) as UsingConvertTo101

The others are shown for demonstration purposes

i am using oracle database . any how i got it solved thank you alots i will post how to do this soon in my thread asking the same question ..
thank u so much for the tip .

[aal_fareed]

Re: HTML Date Format

just wants to make it easier for ppl who are facing same issue .
so formating the date is easy after all , we have to define it in group header properties . by typing the following codes all you have to do is change (birthday) to ur field name and it will work :

<tr>
<td class="[class.gridDataHeader]" colspan="{systemcolumnCount}">&nbsp;</td>
<td class="[class.gridDataHeader]" colspan="100" >
<div>
<script type="text/javascript">
var d=new Date("{your_Field_Name_Here}") \\\\ this for year
var monthname=new Array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")\\\\ for month
document.write(monthname[d.getMonth()] + " ") \\\\ this for month


document.write(d.getFullYear())
</script>
</div>
:

in my case i needed to get the year of my date so check attachment to see where to place the code

Ahmed sh