Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Making CTOD() work in Europe
Message
From
16/11/2018 13:54:50
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01663465
Message ID:
01663470
Views:
77
This message has been marked as the solution to the initial question of the thread.
Likes (1)
>>>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.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform