Hello, I don't if it relevant to ORACLE because I cannot find MAGIC UNIPAAS.
I received this formula from UNIPAAS developer, could you explain me what's the meaning of this formula?
IF (AH_BL_Date+IF (Air Shipment,1,SUPP CI LEADTIME)='01/01/1901'DATE,'00/00/0000'DATE,AH_BL_Date+IF (Air_Shipment,1,SUPP CI LEADTIME))
I don't know what the language is, but if you look at it carefully...
IF (AH_BL_Date+IF (Air Shipment,1,SUPP CI LEADTIME)='01/01/1901'DATE,'00/00/0000'DATE,AH_BL_Date+IF (Air_Shipment,1,SUPP CI LEADTIME))
Let's say 'AH_BL_Date+IF (Air Shipment,1,SUPP CI LEADTIME)'
be equal to 'A'; then it will be...
If A = '01/01/1901'DATE,
Then return value '00/00/0000'DATE
Else return value '01/01/1901'DATE (which is A)
Just my two cents...
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.