I am trying to set up a default value for a date field. I am using C# along with the Mere Mortals Framework. I tried defining a variable with a type of DateTime but that doesn't work. Here's the code I put in my default class:

public struct IssueDetailDefaults
{
        public int IssueNo;
	public datetime IssueDate;
		
	public IssueDetailDefaults(int issueNo)
        {
		this.IssueNo = issueNo;
		this.IssueDate = DateTime.Now;
        }
}

I also want to be able to return a data set based on date ranges and am having the same trouble there. Here's what I tried:

public DataSet GetIssueDetailsByDateRange(DateTime begDate, DateTime endDate)
{
  return this.GetDataSet("SELECT * FROM IssueDetail WHERE " +
	"IssueDate <= '" + endDate + "' and (EMPTY(RetDate) or " +
	"(RetDate >= '" + begDate + "' and RetDate <= '" + endDate + "'))");
}

What am I doing wrong?

Thanks for your help.

Linda