FrontPage Date Format - The "new column" trick
Posted on 2004-09-08
Greetings! I hope someone can help me with a date format problem I'm having.
1. I have an Access database with a date field.
2. The date is formatted as MM/DD/YYYY.
3. Using the FrontPage Database results wizard, I add my database results to an active server page.
4. After uploading to my server, the displayed format changes to DD/MM/YYYY.
What I need to accomplish:
I need to display the date in MM/DD/YYYY format.
Now, there's definitely a method to solve my problem. It involves adding a custom query to the database results wizard. This query creates a new date column (such as "date2"), which is displayed properly on the page.
How do I create this query?
I know someone here will know, and I thank anyone and everyone who tries to help.
Thanks so far,