DateTime

[waelr]

Greetings
I'm trying to generate a report that returns records by comparing DateTime
I'm using selection formula: {TransactionByAmount.mesg_crea_date_time} >= DateTime('" & Dt1 & "') and {TransactionByAmount.mesg_crea_date_time} <= DateTime('" & Dt2 & "') "
Dt1 and Dt2 are 2 variables
Comparing the date works fine but comparing time is incorrect
any help appreciated
thank u

[shukla]

use "#" intead of "'" to compare date

[shakti5385]

Greetings
I
Comparing the date works fine but comparing time is incorrect
any help appreciated
thank u

Just watch the crystal report tutorial at my signature on the post 2 ,
post 2 is related to the date example

where i give the example that how to find the value between two date

hope it will help ful for you

Link at my signature

[shakti5385]

use "#" intead of "'" to compare date

Hi shukla
This wiil not work in the crystal report if you are not using the selection formula for comparing the date see the link at my signature related to the crystal report ,post2

[shukla]

hello shakti
i think by using between clause and "#" statement it will definately going to be work.

{TransactionByAmount.mesg_crea_date_time} between #" & Dt1 & "# and #" & Dt2 & "# "

[shukla]

by the way.
HAPPY DIWALI
ALL OF YOU.

[pame1la]

by the way.
HAPPY DIWALI
ALL OF YOU.

HAPPY DIWALI

[shakti5385]

hello shakti
i think by using between clause and "#" statement it will definately going to be work.

{TransactionByAmount.mesg_crea_date_time} between #" & Dt1 & "# and #" & Dt2 & "# "

Hi shukla
I test this code but some time in the crystal report search this wil not give the batter result
so in the selection formula i change the code
you check this code at my signature at the post 2 in the crystal report tutorial


Happy Deepawali to you