date in field

Scriptcase 8 Discussion
#1

Anyone help me, i have a field {test} , want see the current years in format only 2015,not want other value of time,etc…

#2

create a custom field and assign the data with the correct format. date(‘Y’, {test}) or something similar

#3

ok,done, but i want insert in onload sql, not works…
//
$check_sql = “curdate()”;
sc_lookup(rs, $check_sql);

if (isset({rs[0][0]})) // Row found
{
{data-test} = {rs[0][0]};
}

#4

[QUOTE=andreaparisi;35303]ok,done, but i want insert in onload sql, not works…
//
$check_sql = “curdate()”;
sc_lookup(rs, $check_sql);

if (isset({rs[0][0]})) // Row found
{
{data-test} = {rs[0][0]};
}[/QUOTE]

Why are you asking date to data base? Why arent you formating as Albert suggested? Where are yoiy doing an insert in this code as you mentioned ?

#5

ok but explain how insert code, made field with data,how assign date at {test}, any example,thanks