Hi nate, thanks for the reply. I have used Max function, but, I am unable to the date value into a variable, but I am able to get the Date value in text object
please look at the code below
vTagForPO=(FillA, FillB,FillC);
NoConcatenate
GetPOTime:
SELECT TagName as TagsForPOTime,
DateTime as POTime
FROM
History
WHERE
TagName IN$(vTagForPO)
AND DateTime >= '$(vProdStartTime)'
AND DateTime <= '$(vThisExecTime)'
NoConcatenate
FactGetPOChangeTime:
LOAD
TagsForPOTime,
if(TagsForPOTime='Fill A',POTime,0) as Fill A Time,
if(TagsForPOTime='Fill B',POTime,0) as Fill B Time,
if(TagsForPOTime='Fill C',POTime,0) as Fill C Time
Resident GetPOChangeTime;
LET vFillATime=Max([Fill A Time]);
LET vFillBTime=Max([Fill B Time]);
LET vFillCPOTime=Timestamp(Max(Fill C TIme),'YYYY-MM-DD hh:mm:ss');
when i use the this Timestamp(Max(Fill C TIme),'YYYY-MM-DD hh:mm:ss'); expression in a text object, I am getting the exact value
//LET vFillCPOTime1=Time(Max(Time#([BoschCPOTIme],' YYYY-MM-DD hh:mm:ss')),'YYYY-MM-DD hh:mm:ss');
