× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Birgitta,

Thanks.

I tried my suggestion at work, but came out with the same results you 
described. did not think of using the functions DECIMAL or ZONED.

I was looking for an alternative to prevent using the CASE-statement, as I 
think it is difficult to understand at times. This solution, with nested 
functions, is not the best, either, but would have my preference.

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 27-6-05 at 12:24 Hauser, Birgitta wrote:

>Hi Carel,
>
>>>Would not the following statement do the same?
> 
>>>CHAR(DIGITS(MONTH(CURRENT DATE)), 2)
> 
>The result of your statement will always be '00', because Month() returns an 
>integer value.
>If you convert an integer with digits the result consists of 10 characters. 
>Char takes the first 2 characters.
>But the following statement will return the correct month:
> 
>DIGITS(DEC(MONTH(CURRENT DATE), 2, 0))




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.