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

[Paul_Pillay]

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]

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

[Aleksi_Alkio]

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

[Paul_Pillay]

Ok cheers Aleksi

[Grant_Stead]

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

[Paul_Pillay]

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

How would I capture it as a timestamp?

[Grant_Stead]

@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]

Great! thanks Grant