>>>Hi,
>>>
>>>As I go through my program, I see many places where I convert a string to date, using CTOD(), hard-coded with MM/DD/YYYY. But if the date is (for example), British ("DD/MM/YYYY") it won't work.
>>>
>>>How do you suggest I change all places that use CTOD() from hard-coded use of American date system to another?
>>
>>You don't, the ctod() respects the set date format.
>>Unless you have date constants.
>
>I know that ctod() respects the set date format; but I didn't :). For example, I could have in my program:
>
>This.r_nFirstDay = DOW(CTOD(STR(This.r_nMonth,2,0)+"/01/"+STR(This.r_nYear,4,0)))
>
>The above will not work since when I have SET DATE to BRITISH, the string should be Date Month Year.
You should have used dow(date(This.r_nYear, This.r_nMonth, 1)). Much simpler.