Who's On?

	Membership:
	Latest: Jeffin Joy
	Past 24 Hours: 1
	Prev. 24 Hours: 0
	Overall: 4988

	People Online:
	Visitors: 55
	Members: 0
	Total: 55

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Formating the DATA in a Data Query Object

1 Replies

0 Subscribed to this topic

13 Subscribed to this forum

Sort:

Author

Messages

Chris

New Member

Posts: 0

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

New Poster

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.