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?

[dan_sullivan]

is it possible that some of the data is null in your timestamp variable?

[kmswetha]

It is a single file, stored in a variable? So no chance of null.

THe movement I use Max, it doesn't work

[nilesh_gangurde]

there is possibility that timestamp could be in text format.

use timestamp# function and get actual timestamp format.

Regards,

Nilesh

[kmswetha]

ITS WORKING WHEN I USE MAX STRING

[kmswetha]

EVEN THEN ITS NOT WORKING

[nilesh_gangurde]

share example in qvw or qvf

[antoniotiman]

What is the Filename ?

[kmswetha]

for example you can use file name as

XYZ_20_11_2016_00_12.csv'

[kmswetha]

timestamp(timestamp#(left(right('XYZ_20_11_2016_00_12.csv',20),16),'DD_MM_YYYY_HH_MM'),'MM/DD/YYYY hh:mm:ss TT')