Learn the Rules, Break The Rules, and Create the New Ones...

Hi... My name is Rizky Prihanto. You can call me RQ, or Rizky either. I am currently living on Bandung, Indonesia. Had a lot of works and research about Enterprise Information Systems (majoring on education and e-governments). I have bunch of interests (some friends call it 'freakz') about MySQL Opensource Database and now I am one of the administrator of MySQL Indonesia User Group - the opensource community initialized by Sun Microsystems Indonesia.

My Company PT Cinox Media Insani, Bandung, Indonesia. I work here since 2008 and I take responsibility as Chief of Software Architect. My job is about planning, imaginating, fantasy-ing, concepting, and build the infrastructure of the new information systems (or app engines) which going to be implemented.

This blog This is my blog that represent my current opinion, research and experiences about anything in Software Engineering. Written since 2007 (actually) and has been vaccum for a lot of while. And now I wanna ressurrect this blog (optimistically) from the long-long-hibernation with something fresh and new ideas -- still about MySQL, software engineering, development, and may be something managerial here.

About the tagline I've learned the statement above from some paper written by Kent Beck about Extreme Programming (XP) methodology -- some sort of practical software development methods which have no boundaries. That's very inspiring me a lot. I have written some article on this blog that tell my interpretation about that statement here.

My Another Blogs I have classifying my blogs into some sort of genre. The blog that you read here right now is my primary blog that tell you (majoring) about IT stuff. But if you wanna look another side of me, you can visit here, here, here,or here. Hope it'll be interesting for some of you.

Credits I would thanks to Blogger for this great blog platform. Skinpress who designed this Wordpress template (which is bloggerized by Free Blogger Templates). My appreciate is also going to you who give your generously time for visiting my blog.

Fungsi-Fungsi VB/VBA/VBScript

Date/Time Functions

FUNCTION

DESCRIPTION

CDate

Converts a valid date and time expression to the variant of subtype Date

Date

Returns the current system date

DateAdd

Returns a date to which a specified time interval has been added

DateDiff

Returns the number of intervals between two dates

DatePart

Returns the specified part of a given date

DateSerial

Returns the date for a specified year, month, and day

DateValue

Returns a date

Day

Returns a number that represents the day of the month (between 1 and 31, inclusive)

FormatDateTime

Returns an expression formatted as a date or time

Hour

Returns a number that represents the hour of the day (between 0 and 23, inclusive)

IsDate

Returns a Boolean value that indicates if the evaluated expression can be converted to a date

Minute

Returns a number that represents the minute of the hour (between 0 and 59, inclusive)

Month

Returns a number that represents the month of the year (between 1 and 12, inclusive)

MonthName

Returns the name of a specified month

Now

Returns the current system date and time

Second

Returns a number that represents the second of the minute (between 0 and 59, inclusive)

Time

Returns the current system time

Timer

Returns the number of seconds since 12:00 AM

TimeSerial

Returns the time for a specific hour, minute, and second

TimeValue

Returns a time

Weekday

Returns a number that represents the day of the week (between 1 and 7, inclusive)

WeekdayName

Returns the weekday name of a specified day of the week

Year

Returns a number that represents the year

Conversion Functions


FUNCTION

DESCRIPTION

Asc

Converts the first letter in a string to ANSI code

CBool

Converts an expression to a variant of subtype Boolean

CByte

Converts an expression to a variant of subtype Byte

CCur

Converts an expression to a variant of subtype Currency

CDate

Converts a valid date and time expression to the variant of subtype Date

CDbl

Converts an expression to a variant of subtype Double

Chr

Converts the specified ANSI code to a character

CInt

Converts an expression to a variant of subtype Integer

CLng

Converts an expression to a variant of subtype Long

CSng

Converts an expression to a variant of subtype Single

CStr

Converts an expression to a variant of subtype String

Hex

Returns the hexadecimal value of a specified number

Oct

Returns the octal value of a specified number

Format Functions


FUNCTION

DESCRIPTION

FormatCurrency

Returns an expression formatted as a currency value

FormatDateTime

Returns an expression formatted as a date or time

FormatNumber

Returns an expression formatted as a number

FormatPercent

Returns an expression formatted as a percentage

Math Functions


FUNCTION

DESCRIPTION

Abs

Returns the absolute value of a specified number

Atn

Returns the arctangent of a specified number

Cos

Returns the cosine of a specified number (angle)

Exp

Returns e raised to a power

Hex

Returns the hexadecimal value of a specified number

Int

Returns the integer part of a specified number

Fix

Returns the integer part of a specified number

Log

Returns the natural logarithm of a specified number

Oct

Returns the octal value of a specified number

Rnd

Returns a random number less than 1 but greater or equal to 0

Sgn

Returns an integer that indicates the sign of a specified number

Sin

Returns the sine of a specified number (angle)

Sqr

Returns the square root of a specified number

Tan

Returns the tangent of a specified number (angle)

Array Functions


FUNCTION

DESCRIPTION

Array

Returns a variant containing an array

Filter

Returns a zero-based array that contains a subset of a string array based on a filter criteria

IsArray

Returns a Boolean value that indicates whether a specified variable is an array

Join

Returns a string that consists of a number of substrings in an array

LBound

Returns the smallest subscript for the indicated dimension of an array

Split

Returns a zero-based, one-dimensional array that contains a specified number of substrings

UBound

Returns the largest subscript for the indicated dimension of an array

String Functions


FUNCTION

DESCRIPTION

InStr

Returns the position of the first occurrence of one string within another. The search begins at the first character of the string

InStrRev

Returns the position of the first occurrence of one string within another. The search begins at the last character of the string

LCase

Converts a specified string to lowercase

Left

Returns a specified number of characters from the left side of a string

Len

Returns the number of characters in a string

LTrim

Removes spaces on the left side of a string

RTrim

Removes spaces on the right side of a string

Trim

Removes spaces on both the left and the right side of a string

Mid

Returns a specified number of characters from a string

Replace

Replaces a specified part of a string with another string a specified number of times

Right

Returns a specified number of characters from the right side of a string

Space

Returns a string that consists of a specified number of spaces

StrComp

Compares two strings and returns a value that represents the result of the comparison

String

Returns a string that contains a repeating character of a specified length

StrReverse

Reverses a string

UCase

Converts a specified string to uppercase

Other Functions


FUNCTION

DESCRIPTION

CreateObject

Creates an object of a specified type

Eval

Evaluates an expression and returns the result

GetLocale

Returns the current locale ID

GetObject

Returns a reference to an automation object from a file

GetRef

Allows you to connect a VBScript procedure to a DHTML event on your pages

InputBox

Displays a dialog box, where the user can write some input and/or click on a button, and returns the contents

IsEmpty

Returns a Boolean value that indicates whether a specified variable has been initialized or not

IsNull

Returns a Boolean value that indicates whether a specified expression contains no valid data (Null)

IsNumeric

Returns a Boolean value that indicates whether a specified expression can be evaluated as a number

IsObject

Returns a Boolean value that indicates whether the specified expression is an automation object

LoadPicture

Returns a picture object. Available only on 32-bit platforms

MsgBox

Displays a message box, waits for the user to click a button, and returns a value that indicates which button the user clicked

RGB

Returns a number that represents an RGB color value

Round

Rounds a number

ScriptEngine

Returns the scripting language in use

ScriptEngineBuildVersion

Returns the build version number of the scripting engine in use

ScriptEngineMajorVersion

Returns the major version number of the scripting engine in use

ScriptEngineMinorVersion

Returns the minor version number of the scripting engine in use

SetLocale

Sets the locale ID and returns the previous locale ID

TypeName

Returns the subtype of a specified variable

VarType

Returns a value that indicates the subtype of a specified variable

List function ini dicomot dari sini nieh

1 comments:

Unknown mengatakan...

maaf krna aq bkan orang inggris aq g mengerti blog qt!!!!!

Posting Komentar