johnhardy
asked on
Jmail date format
I have a line in an asp page. jmail
MailObj.appendHTML (rsinput.Fields.Item("Assi gnEnteredD ate").Valu e)
This causes the date to be displayed in American format when the message arrives.
The access database table shows the date in UK format
How can I change the format to show UK format please?
Many thanks
John
MailObj.appendHTML (rsinput.Fields.Item("Assi
This causes the date to be displayed in American format when the message arrives.
The access database table shows the date in UK format
How can I change the format to show UK format please?
Many thanks
John
ASKER
<%
Dim theDate = rsinput.Fields.Item("Assig nEnteredDa te").Value MailObj.ap pendHTML (Day(theDate) & "/" & Month(theDate) & "/" & Year(theDate))
%>
I placed this code near the top of the page but it brings an error
line 5, column 12
Dim theDate = rsinput.Fields.Item("Assig nEnteredDa te").Value MailObj.ap pendHTML (Day(theDate) & "/" & Month(theDate) & "/" & Year(theDate))
Dim theDate = rsinput.Fields.Item("Assig
%>
I placed this code near the top of the page but it brings an error
line 5, column 12
Dim theDate = rsinput.Fields.Item("Assig
Make sure you are pasting 2 seperate lines of code - your post looks like its somehow combined into 1.
Dim theDate = rsinput.Fields.Item("Assig nEnteredDa te").Value
MailObj.appendHTML (Day(theDate) & "/" & Month(theDate) & "/" & Year(theDate))
Let me know the error if it persists.
Dim theDate = rsinput.Fields.Item("Assig
MailObj.appendHTML (Day(theDate) & "/" & Month(theDate) & "/" & Year(theDate))
Let me know the error if it persists.
ASKER
Sorry yes I didnt copy it in as I should.
However I still get the error message below looks like it does not like the = sign
line 5, column 12
Dim theDate = rsinput.Fields.Item("Assig nEnteredDa te").Value
-----------^
However I still get the error message below looks like it does not like the = sign
line 5, column 12
Dim theDate = rsinput.Fields.Item("Assig
-----------^
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Rouchie
Its now working GREAT!
btw as you have used both is it worth changing from .asp to asp.net?
Its now working GREAT!
btw as you have used both is it worth changing from .asp to asp.net?
Definitely yes, simply to avoid all the little pitfalls that make life hard with ASP. The problem is that it works quite differently and has lots more power, so there's quite a steep learning curve.
The tutorials videos on www.asp.net though are a really good place to start should you have a spare few days on your hands :-)
The tutorials videos on www.asp.net though are a really good place to start should you have a spare few days on your hands :-)
Open in new window