asked on

Date as Input Parameter

Hi,

I am struggling to filter a asp.net c# query with a unix date input parameter, I am trying to filter my query results between todays date and a date 14 days later. I think I am getting mixed up with the format of the date to input into the string as I have tried a lot of diferent options but get format string error messages back when I run the page. Here is my code I have so far, ;

DateTime DateParameter = DateTime.Today;
DateTime DateParameter1 = DateTime.Today.AddDays(14);
double Parameter = Util.ConvertToUnixTimestamp(DateParameter);
double Parameter1 = Util.ConvertToUnixTimestamp(DateParameter1);
e.InputParameters["Date"] = Parameter.ToString();
e.InputParameters["Date1"] = Parameter1.ToString();

I have replaced

e.InputParameters["Date"] = Parameter.ToString();
e.InputParameters["Date1"] = Parameter1.ToString();

with

e.InputParameters["Date"] = "1018310400";
e.InputParameters["Date1"] = "101952000";

which works perfectly, but when I run the first bit of code no results are displayed.

Thanks

Chris

Daniel Wilson

What data type is e? There appears to be something in the type conversions that is not as expected ...

Those values you hard-coded to test -- are they EXACTLY what Parameter.ToString() and parameter1.ToString() are returning?

chrispaton

ASKER

This is the select parameter details;

<SelectParameters>
<asp:Parameter Name="Date" Type="String" />
</SelectParameters>
<SelectParameters>
<asp:Parameter Name="Date1" Type="String" />
</SelectParameters>

The values hard coded are supposed to be what the parameter and parameter1 should be returning but are not, I added the hard coded values to make sure that I was parsing something to the page and that my query was correct.

Daniel Wilson

>>The values hard coded are supposed to be what the parameter and parameter1 should be returning but are not.

So Util.ConvertToUnixTimestamp is not performing properly.

Can you post its code?

chrispaton

ASKER

public class Util
{
/// <summary>
/// Convert a date time to unix timestamp
/// </summary>
/// <param name="date"></param>
/// <returns></returns>
public static double ConvertToUnixTimestamp(DateTime date)
{
DateTime origin = new DateTime(1970, 1, 1, 0, 0, 0, 0);
TimeSpan diff = date - origin;
return Math.Floor(diff.TotalSeconds);
}

/// <summary>
/// Convert a unix timestamp to a date time
/// </summary>
/// <param name="timestamp"></param>
/// <returns></returns>
public static DateTime ConvertFromUnixTimestamp(double timestamp)
{
DateTime origin = new DateTime(1970, 1, 1, 0, 0, 0, 0);
return origin.AddSeconds(timestamp);
}
}

Daniel Wilson

What happens if you change the math.floor call to an explicit (long) cast? And return a long?

http://andrewgunn.blogspot.com/2008/07/how-do-i-convert-unix-timestamp-into.html

chrispaton

ASKER

I have changed the math.floor call to (long) and return a long as you suggested but it's still not returning anything.
Please help

ASKER CERTIFIED SOLUTION

Daniel Wilson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

chrispaton

ASKER

hi daniel,
thanks for your help.this was the code we used without the doubles and it works.
e.InputParameters["Date"] = Util.ConvertToUnixTimestamp(DateTime.Today).ToString();
e.InputParameters["Date1"] = Util.ConvertToUnixTimestamp(DateTime.Today.AddDays(21)).ToString();
much appreciated
chris

chrispaton

ASKER

hi daniel.
thanks for your help.
this was the code without the doubles and it works
e.InputParameters["Date"] = Util.ConvertToUnixTimestamp(DateTime.Today).ToString();
e.InputParameters["Date1"] = Util.ConvertToUnixTimestamp(DateTime.Today.AddDays(21)).ToString();
much appreciated
chris