search

SFDO-Community-Sprints / Snowfakery-Recipe-Templates

Repo for all contributed Snowfakery recipes, maintained by Data Gen Toolkit team.
BSD 3-Clause "New" or "Revised" License
27 stars 8 forks source link

Date_between syntax needs "M" for month capitalized in various recipes #142

Closed programmer2coder closed 2 years ago

programmer2coder commented 2 years ago

Recipe Name In NPSP folder:

In PMM folder:

Describe the bug Running the recipe did not give a random range of dates as expected (the ones using the "relative months" option). When using date_between function, for the options start_date and end_date , the "M" for months must be uppercase. The rest are lowercase.

To Reproduce

  1. Run any of the above-named recipes.
  2. Examine the output for field(s) using date_between and months. For example, after running Affiliations_Contact_npsp.recipe, the End Date for Affiliations is all the same date, not a date within the range of past 3 months as expected.

Expected behavior Expect random dates within the range specified by start_date and end_date.

Actual behavior Dates with "m" instead of "M" result in all the same date.

Additional context Snowfakery documentation: [https://snowfakery.readthedocs.io/en/stable/index.html#date_between] The OBF_basic.recipe is the only recipe that has this syntax correct, with the capital M. My first issue creation. Please forgive any newbie errors.