Date Formula for PREVIOUS MONTH as Search Value

Permanently deleted user

• April 27, 2022 18:54

I am currently manually running a flow, and using the dates to indicate the time period the export should cover.  In all cases, it is the month before.  No matter when this month I run this report, I will want last months data.  If I can find a way to put the dates in the Search value and Search value 2 of the beginning of the month and end of the month, respectively.  I can use the Preset scheduling to run this export monthly. 

0

• 

  Amanjot Singh Group Product Manager

  • April 27, 2022 23:46

  

  

  

  

  Hello Todd,

  Thank you for reaching out. We have plans to add support of the advanced field editor (AFE) to the search value fields. It will allow you to specify the search values dynamically. This change is currently in backlog. I would request you to look at future release notifications to see when this problem is being solved.

  Regards,

  0
• 

  Scott Henderson CTO

  • April 28, 2022 00:16

  

  

  

  Can't this be accomplished in the NetSuite saved search directly?  See pic below for context.  NetSuite allows for saved searches to be pre-configured with relative date values for date fields, etc... 

  

  

   

  0

Please sign in to leave a comment.