Announcement

Collapse
No announcement yet.

session variable and time

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

  • session variable and time

    Hi,

    I have created a formA and there is 2 fields in the database "updated_by" and "updated_datetime".

    ​My objective is that whenever a user update a record, the "updated_by" will capture the user's login id and "updated_datetime" will capture the date & time the record is updated.

    updated_by​:
    ​I have this app_Login form whereby there is this event "onValidateSuccess", I tried to declare a global variable [employeeid]={login} there. After which in formA, I put the global value in the database value. Please refer to attached pic. But it seems not working, I am not sure if I do it correctly.


    updated_datetime​:
    I have set the timezone to "Asia/Singapore" in scriptcase setting and the updated datetime fields have bee set as per attached. However, when I update records, the time still does not reflect Singapore timezone.There will be hours different. My desktop time show 11am (SG timezone), the record will show 1am. Is there other setting needs to be done?
    app_Login
Working...
X