topic Re: Field format stay in timestamp in App Development

Field format stay in timestamp

MNicolas — Sat, 16 Nov 2024 02:32:42 GMT

Hello all,

I have an issue with one of my field which is in timestamp and I want it in date. I think the format is staying in cache, because in the script I tried to formate to date (floor, date 'DD/MM/YYYY') and I untagged the field with timestamp, I reload a dozen times, but the format is staying in timestamp untill I rename the field...

Any idea ?

Re: Field format stay in timestamp

agigliotti — Thu, 30 Apr 2020 09:56:46 GMT

let's try to apply the Floor function in the script.

ex. Floor(your_timestamp_field) as new_Date_Field

I hope it can helps.

Re: Field format stay in timestamp

MNicolas — Thu, 30 Apr 2020 10:02:42 GMT

Thanks but as written in my post I tried :

- floor(myfield)

- date(myfield, 'DD/MM/YYYY')

- untagg my field with timestamp

And the timestamp is still here...

Re: Field format stay in timestamp

agigliotti — Thu, 30 Apr 2020 10:07:50 GMT

but i saw that your time is always equals to 0.
maybe could you simple apply a date format in your table column?

Re: Field format stay in timestamp

MNicolas — Thu, 30 Apr 2020 10:14:45 GMT

Yes the time is equal to zero cause I use the Floor function ....

I dont want to use it in a table. In the filters I can't formate the date and I dont want it to appears on the selection as a timestamp

I just want to know how I can get rid of the cache