Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mwscott1
Creator
Creator

Flooring mixed timestamp and date data

In my data I have a mix of timestamps and dates. When I floor this to try and return all entries at dates. It appears only the entries that are dates in the original data are returned. None of the timestamp entries show.

date(floor([Completed Date]),'MM/DD/YYYY') as [Completed Date]

10 Replies
sunny_talwar

What is your TimeStamp data format? Make sure that this format is the same format specified within the environmental variable.

mwscott1
Creator
Creator
Author

mm/dd/yyyy hh:mm

sunny_talwar

Is that the format from environmental variables or is that how the timestamp come in as?

mwscott1
Creator
Creator
Author

this is how the timestamp shows on the .csv file

sunny_talwar

And what is your environmental variable set as?

mwscott1
Creator
Creator
Author

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

sunny_talwar

Try to change this

SET TimestampFormat='M/D/YYYY h:mm';

mwscott1
Creator
Creator
Author

I tried changing that and it still only returns the dates that show in the data as a date. All timestamps are not shown. Just to be clear the original data has both dates and timestamps in the same field.

sunny_talwar

That make sense, would you be able to share a screenshot of a filter object of the field which you load without performing any transformation to....