ASP Date Function

Ken11 · September 30th, 2003, 11:55 AM

I was wondering, is there a function that out puts the day, month and year separately? For example if I wanted to get only the month and store it in a db which function can I use to do so.

Thanks for your assistance in this matter,
Ken

kilika · September 30th, 2003, 12:04 PM

Code:

Month(Now)

will give you the number of the month. For example December will return 12.

Code:

Day(Now)

will give you the day number.

Code:

Year(Now)

will give you the year.

Code:

MonthName(Month(Now))

will give you the name of the month.

Code:

Hour(Now), Minute(Now), Second(Now)

all return their respective data.

Code:

Week(now)

returns the week number.

Code:

WeekDay(Now)

returns the week day number (Sunday = 1, Monday = 2, etc.).

Code:

WeekDayName(WeekDay(Now))

Returns the name of the weekday (Sunday, Monday, etc.).

Now just returns the current time and date. Date could also be used for the date functions as well as any date in string or datetime format. (i.e. day('1/3/03'))

That is all I can think of right off the top of my head, but I am sure there are at least a few more.

Chris

Ken11 · September 30th, 2003, 01:07 PM

Thank you so very much Chris. I appreciate your help immensely.

Kindest Regards,
Ken

kilika · September 30th, 2003, 02:04 PM

not a problem - glad I could be of help.

Chris