How to record select on datetime field?

[Former Member]

HI I want to record select on datetime fields. how to do this ?

[former_member205840]

Hi Paul,

There are 3 ways of doing this :

1. Parameter driven, create datetime parameter and filter based on parameter value

{?parameter}>={datefield}

2. Date Manipulation; comparing database field with manipulated date

{datefield} in lastfullweek  or {datefield}> Currentdatetime -5

3. Hard coded values, comparing against a static date

{datefield} = datetime(2016,06,01 00:00:00)

Thanks,

Sastry

[Former Member]

Hello Paul,

We would require more information on this how you wish to do it.

Some points that you need to make sure while comparing DateTime is that you need to make sure that both the fields are of DateTime data type if one is of Date then you may need to convert it to DateTime by using DateTime() function.

Another one is to make the "Exceptions for Null" to "Default Values for Null" in the Formula editor so as to handle null values for Dates.

Regards

Niraj

[former_member198519]

Try this:

Create data range parameters like this.

1.Create a parameter named Fromdate and select your datetime field.

2.Create 2nd parameter Todate and select your datetime field.

3. Go to record selection formula write like this.

{Date} in {?Fromdate} to {?ToDate}

[abhilash_kumar]

Hi Paul,

Could you provide more details on how wish to filter records based on datetime?

-Abhilash