Who's On?

	Membership:
	Latest: Rich Cowie
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5255

	People Online:
	Visitors: 415
	Members: 1
	Total: 416

	Online Now:
	frank lukomski

New Topics

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

Formating the DATA in a Data Query Object

1 Replies

0 Subscribed to this topic

12 Subscribed to this forum

Sort:

Author

Messages

Chris

New Member Send Private Message

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 Send Private Message

Posts: 1127

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.