Tecnologia, programação e muito Visual FoxPro.

segunda-feira, 28 de janeiro de 2013

Bls: ]] XL-mania [[ Mencari umur

 

Dear Raymond

Menggunakan Formula DATEDIF saja

saya kasi Guide nya untuk Formula ini ya :

=DATEDIF(Date1, Date2, Interval)

Where:
Date1 is the first date,
Date2 is the second date,
Interval is the interval type to return.

If Date1 is later than Date2, DATEDIF will return a #NUM! error. If either Date1 or Date2 is not a valid date, DATEDIF will return a #VALUE error.
The Interval value should be one of

Interval Meaning Description
m Months Complete calendar months between the dates.
d Days Number of days between the dates.
y Years Complete calendar years between the dates.
ym Months Excluding Years Complete calendar months between the dates as if they were of the same year.
yd Days Excluding Years Complete calendar days between the dates as if they were of the same year.
md Days Excluding Years And Months Complete calendar days between the dates as if they were of the same month and same year.



Dari: Raymond Adry <Raymond.Adry@vico.co.id>
Kepada: XL-mania@yahoogroups.com
Dikirim: Kamis, 24 Januari 2013 9:07
Judul: ]] XL-mania [[ Mencari umur

 
Mohon bantuannya bagaimana menampakkan umur dari tanggal lahir seseorang
Seperti pada table dibawah ini
No.
Nama
No Pegawai
Tanggal lahir
Umur
1
Herry C Pelealu
01575
23-Jan-60
 
<-- pada kolom ini yang ditampilkan adalah umurnya =  52
2
Marthen Mantiri
01573
23-Mar-55
 
3
Supriyono
04621
27-Mar-63
 
4
Yusak Bulo'
01548
5-Jul-57
 
5
Djaelani
01244
2-Jan-59
 
6
Mudjib
01156
12-May-56
 
 
 
Terima kasih banyak
 
 
Wasalam
Raymond AR
Northern Area
Disclaimer:
The contents of this email, together with its attachments, may contain confidential information belong to Virginia Indonesia Co., LLC ("VICO") and Virginia Indonesia Co., CBM Limited  ("VICO CBM"). If you are not the intended recipient, please notify the sender immediately and delete this e-mail from your system, and you should not disseminate, distribute, copy or otherwise use this email or any part thereof.


__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)
Recent Activity:
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Merry Christmas. May God bless you and your family...             |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+
.

__,_._,___

Nenhum comentário:

Arquivo do blog