Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
MNicolas
Contributor III
Contributor III

Field format stay in timestamp

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...

MNicolas_0-1588239899034.png

Any idea ?

 

Labels (3)
4 Replies
agigliotti
Partner - Champion
Partner - Champion

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.

MNicolas
Contributor III
Contributor III
Author

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...

agigliotti
Partner - Champion
Partner - Champion

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

MNicolas
Contributor III
Contributor III
Author

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