Of course, one normally puts dates together like that because left
justification works, and we all know how we're always limited by someone
elses standards. :-)
Bill
------------------------------------------------------------------------
----- Original Message -----
*From:* [email protected]
*To:* U2 Users List <[email protected]>
*Date:* 12/16/2013 6:22 PM
*Subject:* Re: [U2] [OT] Interview Questions
There's an xkcd for everthing: http://xkcd.com/1179/
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Bill Haskett
Sent: Monday, December 16, 2013 6:13 PM
To: U2 Users List
Subject: Re: [U2] [OT] Interview Questions
Another option, which I always have done, is to iconv dates in "15 Jan 2013"
format. This always works regardless of which date method is selected.
Don't know why "yanks" do things that irritate you. But then, most people do things that
irritate someone. As Mark Brown always points out; the trouble with standards is everybody has
one. This seems more of an issue than what "yanks" do. :-)
Bill
Untitled Page
------------------------------------------------------------------------
----- Original Message -----
*From:* [email protected]
*To:* [email protected]
*Date:* 12/16/2013 6:00 PM
*Subject:* Re: [U2] [OT] Interview Questions
On 17/12/2013 00:17, Wjhonson wrote:
What is the last Thursday of the current month.
Current Date minus Current Day of Month number plus 1 puts you on the
first of the current month Or you could just Oconv d2/ and replace
the middle number with 01 with Iconv that.
Actually, I think that'll screw up pretty spectacularly! OCONV(@TODAY,
"D2") gives me "17/12/13". If I replace the middle number (or if Kevin
replaced the middle number) we'd both end up somewhere in January! Why
do you Yanks put the least significant number in the middle? That's
crazy!
If you want the first of the month, the easiest way to do it is
FIRST = "01/":OCONV(@TODAY,"D2[M,Y]")
(if I've remembered my syntax correctly). Then to get that into
internal format
I_FIRST = ICONV(FIRST, "D2DMY")
You should NEVER assume that dates are in the format you expect,
unless you are in control (which you aren't, here, seeing as you've
messed up pretty spectacularly :-)
Cheers,
Wol
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
-----------------------------------------
IMPORTANT NOTICE: This message is intended only for the addressee
and may contain confidential, privileged information. If you are
not the intended recipient, you may not use, copy or disclose any
information contained in the message. If you have received this
message in error, please notify the sender by reply e-mail and
delete the message.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
