Avatar billede guzzie Nybegynder
25. april 2001 - 11:19 Der er 5 kommentarer og
1 løsning

date change year

Hey There

I am creating a calender with asp, however my question is this
I have a database with a table called January
in January I have 31 rows for each day of the month however what is the best way to get the database to only show 30 days if there are only 30 days in january or 31 days if there are 31 days ?
Does anyone have any ideas ??
Avatar billede guzzie Nybegynder
25. april 2001 - 11:22 #1
could you use
Select TOP \" & something & \" ??????
something like that ?
and how would you create that value ??
depending on the year ??

Guzzie
Avatar billede kjoller Nybegynder
25. april 2001 - 11:31 #2
some thing like this:

dato=\"01-02-2001\"
dateend=dateadd(\"m\",1,dato)


while not dato = dateend

response.write dato&\"<br>\"
dato=dateadd(\"d\",1,dato)
wend
Avatar billede kjoller Nybegynder
25. april 2001 - 11:32 #3
It was an answer :o)
Avatar billede kjoller Nybegynder
25. april 2001 - 11:36 #4
sorry I miss understod the question, but I hope that you can use it anyway
Avatar billede guzzie Nybegynder
25. april 2001 - 12:29 #5
hmmm thanks anyway but still need another solution
:)
Avatar billede guzzie Nybegynder
25. april 2001 - 14:25 #6
hmmmm
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester