Showing results for 
Search instead for 
Did you mean: 

UserDataSource time format

Former Member
0 Kudos


I need to bind a matrix column with user data source of type "Time" ....but sadly i see there is no such type.

what shall be the best possible workaround.

Please Help


Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

short_text looks to me as the best alternative. As long as you allways use 4 digits (09:00) it will even sort right

or use the unix time thing and use a long number to store the number of seconds sinds 1/1/1970 or something.

If you want to store date and time, and keep it a bit human readable, I would use a sting or number containing "YYYYMMDDhhmmss" (it now is 20051123114925) In that form you can sort it, but can't do any calculations with it.

Answers (0)