caranya ...
buat formula
@Per
Select Case left({Query.Periode},2)
Case "01"
formula = "Januari" & " " & right({Query.Periode},4)
Case "02"
formula = "Februari" & " " & right({Query.Periode},4)
Case "03"
formula = "Maret" & " " & right({Query.Periode},4)
Case "04"
formula = "April" & " " & right({Query.Periode},4)
Case "05"
formula = "Mei" & " " & right({Query.Periode},4)
Case "06"
formula = "Juni" & " " & right({Query.Periode},4)
Case "07"
formula = "Juli" & " " & right({Query.Periode},4)
Case "08"
formula = "Agustus" & " " & right({Query.Periode},4)
Case "09"
formula = "September" & " " & right({Query.Periode},4)
Case "10"
formula = "Oktober" & " " & right({Query.Periode},4)
Case "11"
formula = "November" & " " & right({Query.Periode},4)
Case "12"
formula = "Desember" & " " & right({Query.Periode},4)
Case else
formula = "Maret" & " " & right({Query.Periode},4)
end select
ada lagi sih yang gampang tapi hasilnya jadi bahasa Inggris nggak bisa
kita modip...
Semoga membantu dan menambah ilmu kita
nurfirman wrote:
> Gimana ya... cara konfersi string "09-2004" ke menjadi "September 2004"
>
> atau gimana sih pake fungsi formula select case di CR 8.5
>
> Ada yang bisa mencerahkan
>
> Tenkiu
>
>
>
> Untuk keluar dari millis ini, kirim email kosong ke:
> [EMAIL PROTECTED]
>
>
>
>
>
> SPONSORED LINKS
> Programmer
> <http://groups.yahoo.com/gads?t=ms&k=Programmer&w1=Programmer&w2=Indonesia&w3=Basic+programming+language&w4=Computer+programming+languages&w5=Programming+languages&w6=Java+programming+language&c=6&s=157&.sig=QQ3jf-qPyCuDVOqmjxXLqQ>
>
> Indonesia
> <http://groups.yahoo.com/gads?t=ms&k=Indonesia&w1=Programmer&w2=Indonesia&w3=Basic+programming+language&w4=Computer+programming+languages&w5=Programming+languages&w6=Java+programming+language&c=6&s=157&.sig=gwDT36aV8hG5doSQaoUwSA>
>
> Basic programming language
> <http://groups.yahoo.com/gads?t=ms&k=Basic+programming+language&w1=Programmer&w2=Indonesia&w3=Basic+programming+language&w4=Computer+programming+languages&w5=Programming+languages&w6=Java+programming+language&c=6&s=157&.sig=g8R4hday0lm5D2hL5lG5aQ>
>
>
> Computer programming languages
> <http://groups.yahoo.com/gads?t=ms&k=Computer+programming+languages&w1=Programmer&w2=Indonesia&w3=Basic+programming+language&w4=Computer+programming+languages&w5=Programming+languages&w6=Java+programming+language&c=6&s=157&.sig=RLdM7FZAm3K7raX0D8KsjA>
>
> Programming languages
> <http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Programmer&w2=Indonesia&w3=Basic+programming+language&w4=Computer+programming+languages&w5=Programming+languages&w6=Java+programming+language&c=6&s=157&.sig=CtRXYvnoy1O17UC430cphA>
>
> Java programming language
> <http://groups.yahoo.com/gads?t=ms&k=Java+programming+language&w1=Programmer&w2=Indonesia&w3=Basic+programming+language&w4=Computer+programming+languages&w5=Programming+languages&w6=Java+programming+language&c=6&s=157&.sig=XQJC4fZro9pIX1bkqBwT8w>
>
>
>
>
> ------------------------------------------------------------------------
> YAHOO! GROUPS LINKS
>
> * Visit your group "Programmer-VB
> <http://groups.yahoo.com/group/Programmer-VB>" on the web.
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------------------------------------------------
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
AIDS in India: A "lurking bomb." Click and help stop AIDS now.
http://us.click.yahoo.com/VpTY2A/lzNLAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~->
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
