how do i determine...

# Thread: how do i determine...

1. Senior Member
Join Date
Dec 1969
Posts
339

## how do i determine...

the day of the week on a visitor selected date? example if i have drop down boxes containing the month day & year and from those i shld determine the day of the week it falls to? thanks!

2. Senior Member
Join Date
Dec 1969
Posts
2,854

## RE: how do i determine...

weekday(date) <BR><BR>&#039; returns an Integer 0=sunday ---&#062; 6=saturday. (i think)<BR><BR>HTH.<BR>D.

3. Senior Member
Join Date
Dec 1969
Posts
11,247

## RE: how do i determine...

Wekdayname(weekday(date))

4. Senior Member
Join Date
Dec 1969
Posts
2,809

## LOL!!! Spellchecker!

I&#039;m sorry dude, I couldn&#039;t resist. Last one, I swear...<BR><BR>Wekdayname? You spell worse than Akhilesh. :)

5. Senior Member
Join Date
Dec 1969
Posts
339

## Another question...

Does DateAdd has an alternate? I mean, can i get the date 2 days before? I was able to retrieve the date after by using DateAdd but not the date before...thanks!

6. Senior Member
Join Date
Dec 1969
Posts
11,247

## Weak week wek

all the same to me!<BR><BR>No I&#039;m not that bad anyhow I thought I was good considering this<BR>http://63.236.18.31/forum/social.asp?M=623602&T=623602&F=40&P=1

7. Senior Member
Join Date
Dec 1969
Posts
2,854

## RE: Another question...

Use DateAdd and pass it a negative Number.<BR><BR>DateAdd("d", -2, now()) = 2 days before today!<BR><BR>HTH<BR>D.<BR><BR>

8. Senior Member
Join Date
Dec 1969
Posts
339

## That's pretty neat! THANKS! <eop>

.

9. Senior Member
Join Date
Dec 1969
Posts
2,809