Skip to main content

Nesting Functions in Formulas

  • October 5, 2016
  • 2 replies
  • 44 views
J
Forum|alt.badge.img+3

I would like to nest an additional function at the “then” part of the IF formula:
IF(JobDoneOn = “”, “Due” , DATETIME_FORMAT(JobDoneOn , ‘DD/MM/YY’))

So that it reads:
IF(JobDoneOn = “” , “Due” & DATETIME_FORMAT(NextDue, ‘DD/MM’) , DATETIME_FORMAT(JobDoneOn, ‘DD/MM/YY’))

Any ideas?

    This topic has been closed for replies.

    2 replies

    J
    Forum|alt.badge.img+4

    Hi James

    I’ve just tried essentially what you’ve goT:

    IF({Date 1} = “”, "Due - " & DATETIME_FORMAT({Date 2}, ‘DD/MM’),DATETIME_FORMAT({Date 1}, ‘DD/MM/YYYY’))

    and the results were perfect:

    Am I missing something?

    J
    Forum|alt.badge.img+3
    • James_Samuel
    • Author
    • Known Participant
    • October 6, 2016

    Hi James

    I’ve just tried essentially what you’ve goT:

    IF({Date 1} = “”, "Due - " & DATETIME_FORMAT({Date 2}, ‘DD/MM’),DATETIME_FORMAT({Date 1}, ‘DD/MM/YYYY’))

    and the results were perfect:

    Am I missing something?


    Thank you Julian - I think I needed some sleep to realise I needed to change the formula in the date field I was referencing to use DATETIME_PARSE :stuck_out_tongue:

    Terms & ConditionsAccessibility statement