Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Struggling with scripting to find records between 2 dates


skingjack
 Share

Recommended Posts

Hello,

 

Something I just cannot wrap my head around- downloaded and looked at many sample files from many online sources with no obvious resolution.

 

Background info- a client departs on a journey therefore there is a start & end date for said journey (start_date & end_date fields respectively... both date fields). What I'm seeking to do is script a find to return all the client records that are in between the start and end dates.

 

Any guidance on how to accomplish this task would be greatly appreciated.

 

Thanks

 

Jack

Link to comment
Share on other sites

where $StartDate is the specified start date you want to search on, and $EndDate is the specified end date,

 

Enter Find Mode

Set Field [Clients::End Date; ≤ $StartDate]

Set Field [Clients::Start Date; ≥ $End Date]

Perform Find

Link to comment
Share on other sites

AHunter3,

 

Thank you for the quick response- particularly during the US Thanksgiving festivities. Fyi, I am not having any success recreating the above as of yet but have had limited time to dig into further. Before doing so,it appears I'm going to have to refresh my set field & local variable knowledge.=)

 

Thanks again.

 

Jack

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use