Discussions

Expand all | Collapse all

Date Modified Formula Help

  • 1.  Date Modified Formula Help

    Posted 01-23-2020 15:09
    Edited by Ryan Parr 01-23-2020 15:10
    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), [Salesforce Date Modified],[Date Modified])

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


  • 2.  RE: Date Modified Formula Help

    Posted 01-23-2020 15:14
    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
    ------------------------------



  • 3.  RE: Date Modified Formula Help

    Posted 01-23-2020 15:18
    Ahhh curse of the commas! Thanks Mark!

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



  • 4.  RE: Date Modified Formula Help

    Posted 01-23-2020 15:20
    Edited by Ryan Parr 01-23-2020 15:20
    Mark, It doesn't like the = in that formula. "can't be applied to types Datetime, date"

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



  • 5.  RE: Date Modified Formula Help

    Posted 01-23-2020 15:24
    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
    ------------------------------



  • 6.  RE: Date Modified Formula Help

    Posted 01-23-2020 15:25
    It's a Date field. Should I change them all to Date/time?

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



  • 7.  RE: Date Modified Formula Help

    Posted 01-23-2020 15:27
    no, the opposite, all date fields.

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

    The formula field itself should be a formula Date field type.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 8.  RE: Date Modified Formula Help

    Posted 01-23-2020 15:39
    Danke!

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