With DatePart() function in VBScript language you could take only some parts of current time and display/use in your applications. Following examples will show you and give a brief on this function. .
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.
This function is very useful, if you wish to get date of current SQL server date and time. You may use this function to fill some rows automatically with current time or using with DateDiff function to return the number between current time.
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.
This is an useful but not known functions. If you wish to learn month of date stored in a database, you may use this function placing in a 'SELECT' sql statement
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