max date

[kmswetha]

Hi,

I'm having a file name where I'm extracting date along with time stamp, using timestamp(timestamp(filename)). So far is good.

How ever when I say max  of that field, it returns' -.'

Not sure whats happening.

Any suggestions pls?

[kmswetha]

Hi Sunny, have attached

[sunny_talwar · Accepted solution]

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?

[Colin-Albert]

Try this

!

[Colin-Albert]

app attached

[kmswetha]

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')

[juan_patrick]

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!