Query Failed::  SELECT DISTINCT articles.issue_id,articles.published_date FROM pub_articles_view articles , pub_in_journals journals 
			WHERE articles.item_id=journals.item_id AND journals.journal_id='2' AND articles.published_date   
			BETWEEN '01-01-2006.' AND '12-31-2006.' ORDER BY articles.published_date DESC<br><br>ERROR:  invalid input syntax for type date: "01-01-2006."
LINE 3:    BETWEEN '01-01-2006.' AND '12-31-2006.' ORDER BY articles...
                   ^