format database field

09/09/2003 - 02:57 por Portugalmidi | Informe spam
Hi
i'm a newbie on this so be patient with me
I have a database connection made by frontpage and it's working

One of the lines show a field called data that haves a date content as show
below

<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,Data,Local,Nome_do_computador_remoto,Nome_de_utilizador,Ti
po_de_browser,Carimbo_de_data/hora" s-column="Data" b-tableformat="TRUE"
b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Data&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Data")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="3259" --></td>

I woul like to have thist code showing only month or year or day
something like as i do in vb executing day(datefield) or year(yearfield)

i would appreciate any help
thank you
 

Leer las respuestas

#1 Jhonny Vargas P.
11/09/2003 - 15:29 | Informe spam
you watch the following Function that makes the that you need...

Year(Date)
Month(Date)
Day(Date)

you pardon my English

Saludos,
Jhonny Vargas P. [MS MVP-ASP]
Santiago de Chile




"Portugalmidi" wrote in message
news:3f5d2577$0$190$
Hi
i'm a newbie on this so be patient with me
I have a database connection made by frontpage and it's working

One of the lines show a field called data that haves a date content as


show
below

<!--webbot bot="DatabaseResultColumn"



s-columnnames="ID,Data,Local,Nome_do_computador_remoto,Nome_de_utilizador,Ti
po_de_browser,Carimbo_de_data/hora" s-column="Data" b-tableformat="TRUE"
b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Data&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Data")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="3259" --></td>

I woul like to have thist code showing only month or year or day
something like as i do in vb executing day(datefield) or year(yearfield)

i would appreciate any help
thank you



Preguntas similares