Date Modified Formula Help

Question

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
------------------------------

ryanparr · Answer

Danke!------------------------------Ryan Parr------------------------------

markshnier__you · Answer

thise should workIf([Date Modified]=DATE (2020,1,23), [Salesforce Date Modified],[Date Modified])------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

ryanparr · Answer

Ahhh curse of the commas! Thanks Mark!------------------------------Ryan Parr------------------------------

ryanparr · Answer

Mark, It doesn't like the = in that formula. "can't be applied to types Datetime, date"------------------------------Ryan Parr------------------------------

markshnier__you · Answer

OK, [Date Modified] is a date/time field.&nbsp; can you tell me what the field type is for&nbsp;[Salesforce Date Modified]?&nbsp; Is that a date field or a date/time field type.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Date Modified Formula Help

Related Content

Formula Date Field

Date Field Formula

Add 1 day to date formula

Color Code Date Field based on Formula

Not able to use Date Modified In Subsequent steps in Pipeline