Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
If the conditions are met, you should get 'Not Yet Due', else you will have Null() for 3rd timestamp
Hello!
Your condition will return 'Not Yet Due' or NULL
If the file is not yet received and fiscal week end time is less than 24 hours ( a day) from the load time , the flag would be marked as 'Note Yet Due'.
IF(Condition is True, 'if True, FirstStatmentTo Write', 'Else This Statment')
If we donot specify 'Else This Statment', it will take Null()
Hi to All,
i am very happy for your replies and thanks.
Can you please explain me each step dont mine.
regards
prathap.
so
condition is IsNull(FileReceivedTimeStampPMCTTemp) and FiscalWeekEndDateTimeliness - now() >=Timestamp#('24:00:00','hh:mm:ss')
if it returns true your field will be 'Not Yet Due'
if it returns false your field will be 'NULL'
check this for basic learning?
Hi
Is null(FileReceivedTimeStampPMCTTemp)----> what it will return.
now()>=Timestamp#('24:00:00','hh:mm:ss')----> what it will return
i want to know what these are return.
can please explain me?
if(IsNull(FileReceivedTimeStampPMCTTemp) and FiscalWeekEndDateTimeliness-now()>=Timestamp#('24:00:00','hh:mm:ss'),'Not Yet Due') as [3rd timestamp],
deconstruction into readable pseudo-code results in:
IF FileReceivedTimeStampPMCTTemp IS NULL // Not yet received
AND ( FiscalWeekEndDateTimeliness - now() ) >= 24 hours // more than 1 day to go
THEN
put string "Not Yet Due" -> field [3rd timestamp]
ELSE
put NULL -> field [3rd timestamp]