There's an xkcd for everthing: http://xkcd.com/1179/
-----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] 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:* antli...@youngman.org.uk *To:* u2-users@listserver.u2ug.org *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 > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users