Hi,

I have a db with articles an dates
When I had put updates I will that these text shows in my page (html)

Last update on (here comes the date) with (here comes the count of articles)
articles

My sql query in DW with Asp looks like this:

SELECT Count (ProduktID)
FROM Artikels
WHERE OpnemenInWebShop =-1 and Artikelgroep = 22 and
Format(Datum,'dd/mm/yyyy') =(select Max( Date()) from Artikels)

It seems to working,
But when I did yesterday the update, It shows today 0 articles

also I can't select the date

SELECT datum,Count (ProduktID)

Does not work; I have the error that expressions Date not a part is of a
static function
Who can help me?

Vivian