If condition with time format

[sakshikaul]

Hi,

I want to implement the following:-

1. Where the time_of_receipt field in straight table is blank I want to replace with the word 'PNR' in the image attached.

[Taoufiq_Zarra · Accepted solution]

maye be :

if(len(trim(time_of_receipt))<1,'PNR',time_of_receipt) as time_of_receipt,