Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GOMONTH() conundrum
Message
From
29/11/1999 12:36:52
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
29/11/1999 12:26:29
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00296419
Message ID:
00296423
Views:
23
>Hi folks!
>
>The GOMONTH() function, as you may know, returns a date that is "n" months ahead of or behind the supplied date value. For example, GOMONTH(DATE(),12) will return 11/29/2000. This is good.
>
>Now, the value of DATETIME() is 11/29/1999 12:22:23 PM. GOMONTH(DATETIME(),12) returns 12/29/2000 (yes, a date and not a datetime). This is bad.
>
>If you have something that goes into effect at 12:00:00 PM on 11/29/1999, what would you do to automatically determine that it expires 11:59:59 AM on 11/29/2000?
>
>I came up with a way but it's klunky. Anybody have any ideas?


Hi John,
ltTime = {^1999/11/29 12:22:23 PM}
ctot(dtoc(gomonth(ltTime,12))+" "+ttoc(ltTime,2))
?
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform