SharePoint2010: Setting DateTime as Parameter to CAML Query
Well in case of CAML, normal datetime format doesnot work. For that reason we need to convert the input format as given below:
public static String ToSPDate(String strDt)
{
if (strDt == String.Empty)
return strDt;
else
return (Convert.ToDateTime(strDt)).ToString("yyyy-MM-dd");
}
/* -- Format for DateTime Field -- */
public static String ToSPDateTime(String strDt)
{
if (strDt == String.Empty)
return strDt;
else
return (Convert.ToDateTime(strDt)).ToString("yyyy-MM-ddTHH:mm:ssZ");
}
public static String ToSPDate(String strDt)
{
if (strDt == String.Empty)
return strDt;
else
return (Convert.ToDateTime(strDt)).ToString("yyyy-MM-dd");
}
/* -- Format for DateTime Field -- */
public static String ToSPDateTime(String strDt)
{
if (strDt == String.Empty)
return strDt;
else
return (Convert.ToDateTime(strDt)).ToString("yyyy-MM-ddTHH:mm:ssZ");
}
Comments
Post a Comment