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.

[sunny_talwar]

If the conditions are met, you should get 'Not Yet Due', else you will have Null() for 3rd timestamp

[t_chetirbok]

Hello!

Your condition will return 'Not Yet Due' or NULL

[tresesco]

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'.

[Anonymous]

IF(Condition is True, 'if True, FirstStatmentTo Write', 'Else This Statment')

If we donot specify 'Else This Statment', it will take Null()

[#6]

Hi to All,

i am very happy for your replies and thanks.

Can you please explain me each step dont mine.

regards

prathap.

[t_chetirbok]

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'

[Anonymous]

check this for basic learning?

If Statements in C - Cprogramming.com

if...else statement in C

IF & Else condition

[#9]

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?

[Peter_Cammaert]

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]