aparna_desh
December 26th, 2005, 02:32 AM
Hi, I am genrating one report. In that report user will enter from time, date & to time, date. I want to display transaction betweem that date & time range. if i am using only date then it is working properly, but if i am including time, i am not getting accurate result. how can i do it. wht is the syntax for time range also suggest me . shold i store date & time in different field or the in the same filed in database.
For dtae range i am using following syntax
{Command.ReciptDate} in Date(" & VBA.Format(dtpFromdate.Value, "yyyy, MM, dd") & ") to Date(" & VBA.Format(dtpToDate.Value, "yyyy, MM, dd ") & ")
For dtae range i am using following syntax
{Command.ReciptDate} in Date(" & VBA.Format(dtpFromdate.Value, "yyyy, MM, dd") & ") to Date(" & VBA.Format(dtpToDate.Value, "yyyy, MM, dd ") & ")