Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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