Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Re: max date

Hi Sunny, have attachedtimestamp issue.png

Re: max date

Can you share the expression behind your second box which is showing null? Also, it seems you have two spaces between your date and time? Did you make sure that you took care of that in your interpretation function?

View solution in original post

Highlighted

Re: max date

Try this

timestamp_test.JPG

!

Highlighted

Re: max date

app attached

Highlighted
Creator
Creator

Re: max date

Sunny, You are right.Space is the issue.

Used below expression. Removed space between YYYY and hh. Never knew it cause a problem. Thanks a ton.

TimeStamp(TimeStamp#(Left(Right('XYZ_20_11_2016_00_12.csv',20),16),'DD_MM_YYYY_hh_mm'),'MM/DD/YYYYhh:mm:ss TT')

Highlighted
Creator
Creator

Re: max date

Hi Swe Tha

Max function is for number fieldd, so you have to convert this field to number or use maxstring as you mencioned above.

Good luck!