Self explaining sort scripts to compare dates. You may use them to display your age, time period fromm a given date or happening etc. (DateDiff, Timer)
In this tutorial we will compare dates. We will use DateDiff function. You may compare any two valid dates calculation year, day, month, week, minute ans seconds.
Have you ever wanted to format a date in your ASP pages (using VBScript) to conform with RFC-822? These are required for various things but in particular they are required format for dates in RSS feeds. While I was producing some RSS feeds I couldn't find any functions that converted ASP dates to the required formats so I created the following functions to do it for you
The author writes "Many places on the web feature the date that the current document was last modified on. Rather than changing the date manually, using a FrontPage WebBot, or targeting the document by writing it directly into the script, let the server ask the document for the info and it will tell you. This scriptwriter will output code that can be placed on any .asp document on your server and will display the date and time it was last modified in a number of varieties."
There are a number of ways to have users input dates into your application. Dropdown menus are the preferred method employed as there
will certainly be less error checking on dropdown input as compared to textbox
input. Utilizing the date() functions the current date (or any date you prefer by adjusting the date value) can easily be made the pre-filled selected
value. Here you will find two examples: one that displays the current date with a range of days prior, and the other that displays the current date out of all the dates in a range
of years.
In this source code, you may see how can you display date in diffrent formats. This simple ASP code displays current time in short, long and regional settings.
When inserting a date into an Access database you should use the format YYYY-MM-DD. Our function AccessDate returns a date in YYYY-MM-DD format.
When working with a date in Access always use the # delimiters in your SQL statement.