Hi, Is it possible to change the format of "...

(Paul Pillay) #1

Hi,

Is it possible to change the format of “ChangeTimeStamp” to UseLongDateFormat? i.e it currently displays “07/06/2018 19:23:00” and would like it to be “07 Jun 2018 19:23:00”

Thanks

(Aleksi Alkio) #2

I’m afraid we don’t have that option at this moment.

(Aleksi Alkio) #3

If you really need that format, you can CONCATENATE that with the formula. Little bit complex, but doable.

(Paul Pillay) #4

Ok cheers Aleksi

(Grant Stead) #5

@Paul_Pillay another option is to add a virtual column, or a physical… Type datetime, and set it to long

(Paul Pillay) #6

If I set a virtual or physical column as datetime with long.

How would I capture it as a timestamp?

(Grant Stead) #7

@Paul_Pillay you use both… Have the [change_timestamp], and hide it, And then make a virtual column just for viewing… Make the app formula =[change_timestamp]

(Paul Pillay) #8

Great! thanks Grant