5 Replies Latest reply: Jun 14, 2016 5:38 AM by Gabor Tarnoczai RSS

    Use new create field to create another field in the same script

    lingling Guo

      Hi, I have problem with using the new create field  "Tender" to create another field "PEP".

       

      Date([Start Date]) as "Start",

      Date([End Date]) as "End",

      Date(IF([Start Date]='', (''), AddMonths([Start Date],-4) ) )as "Tender",


      Date(IF([Budget Type]=('CAPEX'), IF([Tender]=(''), (''), AddMonths([Tender], -3) ), ('') )) as "PEP"

      Capture.PNG


      And it is possible to use rename field with the new name? for example instead of:

      Date(IF([Start Date]='', (''), AddMonths([Start Date],-4) ) )as "Tender", can i use Date(IF([Start]='', (''), AddMonths([Start],-4) ) )as "Tender"?