Convert formula from 24 hrs to month to date

[rico7937]

I am using crystal reports v10 and need to try to convert this formula from showing the past 24 hrs to a month to date formula ( showing from 00:00:01 on the 1st of the month thru 23:59:59 on the last day of the month). Can someone help me out ?


DTSToDateTime(tzcvtConvToLocalDatetimeByName(ToText(DateTime({PROBLEM.OPEN_DATE},{PROBLEM.OPEN_TIME}),"MM/dd/yyyy hh:mm tt"),"Eastern Standard Time"))
In DateTime (totext (Date(DateAdd ("d",-1,Cdate(year(CurrentDate),month(CurrentDate),day(currentdate))))) & " 00:00:01")
To DateTime (totext (Date(DateAdd ("d",-1,Cdate(year(CurrentDate),month(CurrentDate),day(currentdate))))) & " 23:59:59")

 

[dgillz]

Will this always be for the current month or will this be looking at past or future months?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[rico7937]

This will always be for the current month

 

[rico7937]

Anh advice ?

 

[dgillz]

Time should not enter into this at all right? You just want all records in the current month?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[rico7937]

That can be a true statement. I just need to pull in all records form the 1st of the month to the end. This report will run daily 7 days a week and that is why I am trying to use the Month to date statement. If there's a btter way please let me know. Thanks !

 

[dgillz]

Why not use:

{YourField} in MonthtoDate

This would not work for future dates, so if something is post dated, but still in March 08, it will not show on the report.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[rico7937]

That is what I am trying to do with this formula in the record selection:

DTSToDateTime(tzcvtConvToLocalDatetimeByName(ToText(DateTime({PROBLEM.OPEN_DATE},{PROBLEM.OPEN_TIME}),"MM/dd/yyyy hh:mm tt"),"Eastern Standard Time"))
In DateTime (totext (Date(DateAdd ("d",-1,Cdate(year(CurrentDate),month(CurrentDate),day(currentdate))))) & " 00:00:01")
To DateTime (totext (Date(DateAdd ("d",-1,Cdate(year(CurrentDate),month(CurrentDate),day(currentdate))))) & " 23:59:59")

The problem is that the tickets come out in Grennich time and I need to convert them over to Eastertn Standadrd time, I am getting the correct data it's just the time is not changing over to EST. Any suggestions ?

 

[CR85user]

As dgillz states:

DTSToDateTime(tzcvtConvToLocalDatetimeByName(ToText(DateTime({PROBLEM.OPEN_DATE},{PROBLEM.OPEN_TIME}),"MM/dd/yyyy hh:mm tt"),"Eastern Standard Time"))
In MonthToDate

Would do for your current needs.

'J