Prev
Next
Forums Lawson Design Studio

Formating the DATA in a Data Query Object

Sort:
You are not authorized to post a reply.
Author
Messages
Chris
Basic Member
Posts: 21
Basic Member
12/11/2008 2:37 PM
    Hello,

    I am using Design Studio's Data Query Objcet to pull some data from our database. However i want to do something to this data, like add my own formating in there. For a few examples, I have a date field, I would like to tack the the day of the week onto it. Another example is i have a time field that is stored in the DB as "16:00:00" but i want it to display as "4:00 PM".

    Has anyone tried doing any data formating? is it even possible? i am really hoping that i am not stuck with using the data as it is formated in our DB.

    Thanks
    Chris
    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
    12/11/2008 3:02 PM
      You are correct that you can't change the format within the query but you should be able to convert the value using JavaScript's variable.getHours() and variable.getMinutes() functions.
      David Williams
      You are not authorized to post a reply.