Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Are you wanting to get this in the script or in a chart?
-Rob
in a chart ,
thank you for your reply
Date(Min(TOTAL IRLTID))
TOTAL gives me the same value for all rows
Sorry. When you said "first date in a table" I assumed you meant first for the entire table.
-Rob