Fine be that way. Personally I always *write* my dates as dd MMM yy format anyway, which can be universal, since the MMM is alphabetic and therefore can't be mistaken for anything else.
It's just hard to get my clients to appreciate that universality when their customers are all within a 50 mile radius. -----Original Message----- From: Kevin King <ke...@precisonline.com> To: U2 Users List <u2-users@listserver.u2ug.org> Sent: Mon, Dec 16, 2013 6:29 pm Subject: Re: [U2] [OT] Interview Questions Well now... this is getting interesting. Wol has a very valid point. Assumptions can be deadly. Hence why I called Will out on his. It's minor in the sense of this dialogue, but if when customers are putting up money for the end result assumptions and misunderstanding can be the difference between getting the gig or getting the boot. On Mon, Dec 16, 2013 at 7:13 PM, Bill Haskett <wphask...@advantos.net>wrote: > 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 > _______________________________________________ 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
