Ass. Wr. Wb.
Mas Aksan,
Thank;s Jlan mas
Wass.Wr.Wb.
Riyan
mailto:[EMAIL PROTECTED]
______________________ Reply Separator ______________________
> -----Original Message-----
> From : aksan kurdin, [EMAIL PROTECTED]
> Sent : Thursday, January 3, 2008, 1:20:26 PM,
> To : [email protected]
> Cc :
> Subject: [belajar-access] Format Tahun dari field type Datetime di SQL Server
> select tanggal, year(tanggal) as tahun from tabelanu
> aksan kurdin
> On 1/2/08, Riyan <[EMAIL PROTECTED]> wrote:
>>
>> Ass. Wr. Wb.
>> [email protected] <belajar-access%40yahoogroups.com>,
>>
>> Kalo di Access tinggal buat field baru
>> diquery desain kemudian disi dengan
>> Tahun:format([tgl_entry],"yyyy")
>>
>> Kalau di SQL Server 2000 gimana ya rekan2 suhu access.
>>
>> Terima kasih sebelumnya atas jawabannya
>>
>> Wass.Wr.Wb.
>>
>> Riyan
>> mailto:[EMAIL PROTECTED] <riyan%40spij.co.id>
>>
>>
>>