Prev
Next
Forums User Experience Lawson Design Studio

Formating the DATA in a Data Query Object

 1 Replies
 0 Subscribed to this topic
 12 Subscribed to this forum
Sort:
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