Start and End Time format

[Kuroshi]

I have a formula field for Start and End Time. I wanted to change the format of that two formula field to '00:00 AM/PM'. Tried to change the format in DataPage but that does not work for me.

Here is my formula: 
CONVERT(VARCHAR, [@field:date_start], 114)
CONVERT(VARCHAR, [@field:date_end], 114)

[Barbie]

Hi,

Can you try this code instead?
CONVERT(DATETIME, [@field:date_start], 114)
CONVERT(DATETIME, [@field:date_end], 114)

I hope this works for you.

[Glitch]

These are the frequently used Date Formats. Might help:

101	mm/dd/yyyy
102	yyyy.mm.dd
103	dd/mm/yyyy
104	dd.mm.yyyy
105	dd-mm-yyyy
108/114	To get the time
110	mm-dd-yyyy
111	yyyy/mm/dd
112	yyyymmdd
126	yyyy-mm-dd

[imJihyo]

Hello there! Just dropping Caspio's function reference link here since they have a sample of this formula:

Function Reference - Caspio Online Help

- Jihyo ♥

[astroboy]

Hi, if you are also using date fields for your parameters, you may check out the formatting options in this HowTo article:

https://howto.caspio.com/parameters/displaying-parameters/

[Kurumi]

Hi - Just to add, here's a new post to disable the dates in a custom calendar date picker: 

[Flowers4Algernon]

Hi, this post might also be helpful: