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