JodyFischer
asked on
Military Date Format
I have a date field in an Oracle database and another one in a SQL database. It is a date field but instead of display 7/10/08 I need it to display 10 July 2008. How do I do this?
Last Comment
Try this: x = Format(Now, "dd mmmm yyyy")
Or is this VB Script?
ASKER
Since the date is pulling from the database, it needs to format an existing date. Variable is
recordsx("DATE_ISSUED")
recordsx("DATE_ISSUED")
ASKER
asp programming
So VBScript. Only function that is close is FormatDateTime
dbDate = "7/10/2008"
outDate = FormatDateTime(dbDate, vbLongDate) will result in October 7, 2008
Is July 10, 2008 a useable format for you. If so, we can reconstruct dbDate into "10/7/2008" and push through FormatDateTime function. If you want 10 July 2008, will need additional custom code.
dbDate = "7/10/2008"
outDate = FormatDateTime(dbDate, vbLongDate) will result in October 7, 2008
Is July 10, 2008 a useable format for you. If so, we can reconstruct dbDate into "10/7/2008" and push through FormatDateTime function. If you want 10 July 2008, will need additional custom code.
ASKER
it displays the date shown above just by doing a response.write. I need to make it 10 July 2008.
Please let me know what additional code is needed.
Please let me know what additional code is needed.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Visual Basic Classic
Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.
165K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
