topic Re: Convert Timestamp to time only in App Development

Convert Timestamp to time only

evansabres — Thu, 14 May 2020 18:57:24 GMT

I have a field 'ActivityDate' that appears as such: 2019-12-29 19:65:47.330 I want to convert this to time, specifically AM/PM time format. Ideally, I want to do this in the script, how can I achieve this?

Re: Convert Timestamp to time only

Or — Thu, 14 May 2020 19:49:37 GMT

I think you'd have two options here, both of which should work:

1) MakeTime(Hour(YourTime),Minute(YourTime),Second(YourTime))

2) Time(Frac(YourTime))

Either one can be further formatted, of course.