IF condition

[#1]

Hi All,

if(IsNull(FileReceivedTimeStampPMCTTemp) and FiscalWeekEndDateTimeliness-now()>=Timestamp#('24:00:00','hh:mm:ss'),'Not Yet Due') as [3rd timestamp],

FileReceivedTimeStampPMCTTemp  and   FiscalWeekEndDateTimeliness  ----> these two are the fields in my table.

If i run above IF condition what it willl rerurn ??

Please help me out this issue.

Thanks IN advance.

Regards

prathap.

[t_chetirbok]

isnull() function use to checking if the value is NULL, it returns TRUE if value is NULL and FALSE value is not NULL.

Timestamp# is function to transform value ('24:00:00') to needed format ('hh:mm:ss')

and your expression FiscalWeekEndDateTimeliness - now() returns TRUE if it >= 24 hours and FALSE if < 24 hours

and if both conditions are TRUE, your if statement returns TRUE