Announcement

Collapse
No announcement yet.

date in field

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • date in field

    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
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #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]};
      }

      Comment


      • #4
        Originally posted by andreaparisi View Post
        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]};
        }
        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 ?
        /Giuseppe

        Professional Scriptcase Services
        Some Customers opinions

        Comment


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

          Comment

          Working...
          X