Min(date)

[fbi]

Hello,

I have a date field and in the script is as follows:

Date(Date#([IRLTID],'YYMMDD'),'YYYY-MM-DD') as IRLTID

now I want to get the first date in a table and I tried following solutions but none working:

Min(IRLTID)

Min(Date(Date#(IRLTID,'YYMMDD'),'YYYY-MM-DD'))

Date(Min(IRLTID))

[rwunderlich]

Are you wanting to get this in the script or in a chart?

-Rob

[fbi]

in a chart , 

thank you for your reply

[rwunderlich]

Date(Min(TOTAL IRLTID))

[fbi]

TOTAL gives me the same value for all rows

[rwunderlich]

Sorry. When you said "first date in a table" I assumed you meant first for the entire table.

-Rob