Calculation for text

Viewing 1 reply thread
  • Author
  • August 25, 2021 at 8:05 AM #45033

    David Gordon

    I have a field which I want to automatically have text after a certain date (which is in my Date field). So if its after 01 August 2021 the field will say “Hello World” (or somesuch!). For records before this date, the field will remain blank.

    So something like

    IF ( [DATE]
     < DATEVALUE("2021-07-01"; "yyyy-MM-dd")   “Hello World”;  “”)

    But that’s not working for me. Any clues?

    • This topic was modified 3 months ago by David Gordon. Reason: Typo
    August 26, 2021 at 12:34 AM #45037

    T.L. Ford

    You are missing a ; and using “smart” quotes. See attached. IF([DATE]
    <DATEVALUE("2021-07-01";"yyyy-MM-dd");"Hello World";"xx")

    • This reply was modified 3 months ago by T.L. Ford.
    You must be logged in to view attached files.
Viewing 1 reply thread

You must be logged in to reply to this topic.