 |
|
Re:How to make a date ordered CB list with automat
|
|
Date: 2006/02/16 23:37
|
By: irgendwer
|
Status: User
|
|
|
Karma: 2
|
|
Senior Joomlapolitan
| Posts: 87 |   |
|
|
Is it also possible to create a list which shows the next birthdays which dates users have put in their profile?
South Korea's got Seoul
|
|
The administrator has disabled public write access. |
|
 |
|
Re:How to make a date ordered CB list with automat
|
|
Date: 2006/02/18 04:13
|
By: hfhs
|
Status: 
|
|
|
Karma: 1
|
|
Junior Joomlapolitan
| Posts: 35 | |
|
|
|
I really liked the idea of creating Announcements and then only showing the ones that have content. Is it possible to show those announcements in a module or in content on the frontpage? Or for that matter any of the cb fields on the frontpage, kind of like the Latest Forum Posts module?
|
|
|
The administrator has disabled public write access. |
|
|
|
|
Re:How to make a date ordered CB list with automat
|
|
Date: 2006/02/21 03:31
|
By: djsdjs
|
Status:
|
|
|
Karma: 3
|
|
Senior Joomlapolitan
| Posts: 69 | |
|
|
For birthdays in the future, I googled this one for you - but haven't tried it within CB:
| Code: |
where datepart(dy, dateadd(d, -datepart(dy, GetDate())+1,
dateadd(year, datediff(year, @BirthDate, getDate()),
@BirthDate)))-1 between 0 and 30
|
It is from: http://r937.com/birthdays.html
Post edited by: djsdjs, at: 2006/02/20 21:32
|
|
|
The administrator has disabled public write access. |
|
 |
|
Re:How to make a date ordered CB list with automat
|
|
Date: 2006/05/11 09:28
|
By: MadPax
|
Status: User
|
|
|
Karma: 3
|
|
Junior Joomlapolitan
| Posts: 33 | |
|
|
Great Article, Thnks Nick for the suggestion.
One question though. Where's this DATE_SUB subroutine come from? Are there any such subroutines elsewhere for us to use in the advanced filter?
Hey Nick you deserve Karma for... errrrr... let me put it this way, a hell of a lot of things besides the fast response on my question.
tkare
Pax
|
|
|
The administrator has disabled public write access. |
|
|
