Help with a date problem

[Ben_Kutner]

I have a question that you may be able to help me with. I^m trying to modify a report that hasn^t changed in a while, and I noticed, perhaps because I^m using a later version of R&R, that the low-scope and high-scope dates now need to be entered as mm/dd/yyyy. In the past, we entered them as yyyymmdd.____This has wreaked havoc with my formulas to determine record selection for the current month. I thought I could fix it, but I^m hitting a wall for all months below October (single digit months). It appears that even though I enter a Low Scope of 04/01/2003 the R&R field called loscope() returns 4/1/2003 (stripping the leading zeros).____Subsequently, I can^t figure out how to get a valid "date" that I can manipulate.____The old formula for a field called PickLowDat was: CTOD(substr(loscope(),5,2)+"/"+substr(loscope(),7,2)+"/"+substr(loscope(),1,4))__ with a similar formula for PickHghDate. This returned a character value of "mm/dd/yyyy" which could then be easily manipulated.____I need a way to get a loscope() value of 4/1/2003 into the above "mm/dd/yyyy" mode.____Any suggestions would be appreciated.____Thanks, Ben

[kfleming]

Date settings for a report are controlled by the setting in the Windows control panel at the time the report is created.__The only way that their default can be changed is to open the report and while the report is open, go to the control panel, change its date setting and then return to the report.__So if you do this and set the windows default to yyyymmdd while the report is open, when you go back to the report, you will see that it has changed. Save the report and then next time you open it, it will still be ok. Again, the only thing that can make it change is by changing the control panel WHILE the report is open.____Hope this helps.____Kathleen__R&R Support