Forum Discussion

RyanParr's avatar
RyanParr
Qrew Assistant Captain
6 years ago

Date Modified Formula Help

We're migrating from Salesforce. I'd like to show the SF date modified date if the QB date modified date = 1/23/2020.  All of the fields below are date fields. If([Date Modified]=DATE (1/23/2020), ...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
thise should work

If([Date Modified]=DATE (2020,1,23), [Salesforce Date Modified],[Date Modified])

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
RyanParr's avatar
RyanParr
Qrew Assistant Captain
6 years ago
Ahhh curse of the commas! Thanks Mark!

------------------------------
Ryan Parr
------------------------------
  • RyanParr's avatar
    RyanParr
    Qrew Assistant Captain
    6 years ago
    Mark, It doesn't like the = in that formula. "can't be applied to types Datetime, date"

    ------------------------------
    Ryan Parr
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      OK, [Date Modified] is a date/time field.  can you tell me what the field type is for [Salesforce Date Modified]?  Is that a date field or a date/time field type.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • RyanParr's avatar
        RyanParr
        Qrew Assistant Captain
        6 years ago
        It's a Date field. Should I change them all to Date/time?

        ------------------------------
        Ryan Parr
        ------------------------------