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