Answers.Body: <p>Membership dates are stored as SQL DATE types, for historic reasons, and most other dates in CiviCRM are stored as an SQL DATETIME. I suspect CiviRules doesn't support DATE, only DATETIME.</p>
  <p>So if I'm correct, to fix this, someone would either need to update CiviRules to support DATE or update CiviCRM to use DATETIME for memberships (which probably should be done anyways).</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-08-02T09:54:56.210Z
Answers.Text: I checked the date format on the demo system (https://demo.circle-interactive.co.uk/) and here, Membership is also using date values instead of datetime (checked via API). So this cannot be the (only?) problem here.
Answers.UserDisplayName: emma
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-07-01T19:05:15.297Z
Answers.LastActivityDate: 2023-07-01T19:05:15.297Z
Answers.UserDisplayName: Lars SG
Body: <p>I am trying to create a Civi rule that will be triggered by &quot;Membership is changed&quot; and then set the end date of this membership to a new value. (This rule is needed as a workaround for another bug in how CiviSepa interacts with one-time membership contributions.)</p>
  <p>When I create an Action for this rule, I select &quot;Update Date Value&quot;, as this seems to be the action most close to what I need (modify end date). I get redirected to a page asking for &quot;Source Field&quot;, &quot;Target Field&quot;, &quot;Operation&quot; and &quot;Operand&quot;. When I click on the down-arrow on the right side of &quot;Source Field&quot; and &quot;Target Field&quot;, no drop-down menue is opening. Instead, only a grey line appears when I click, and disappears when I click again.
  The same happens when I select the action &quot;Advanced Update Date Value&quot;.</p>
  <p>Does anybody know what could be the problem here? I get no error whatsoever.
  The rule has no Conditions and no Delay-Action, it contains nothing but a name and a trigger.</p>
  <p>Edit:
  I tested this on a <a href="https://demo.circle-interactive.co.uk/" rel="nofollow noreferrer">CiviCRM demo page</a> running the version 5.62.0. In this demo system, I was able to add a Rule with the trigger &quot;Membership is changed&quot; and the action &quot;Update Date Value&quot;. I was able to choose &quot;Start Date&quot; in &quot;Source Field&quot; and &quot;End Date&quot; in &quot;Target Field&quot;.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-06-20T15:23:54.170Z
Comments.Text: I'm afraid I do not have an answer for you, but I can confirm the behaviour on Civi 5.61 on WordPress. I tried adding a condition, but it made no difference. There don't seem to be any other logical choices for what you are looking for. CiviRule is sometimes a bit arcane, so I may be missing something.
Comments.UserDisplayName: kapn
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-07-25T21:53:55.363Z
Comments.Text: Your "Edit" suggests this is now working on Demo? If so you may just need to upgrade or wait on the next release - or add an Answer yourself to say 'this is now fixed'
Comments.UserDisplayName: petednz - fuzion
Tags: <civimember><civirules>
Title: CiviRules "Update Date Value" - I cannot select any source or target field
ThreadText: # CiviRules "Update Date Value" - I cannot select any source or target field
  
  (Asked by: username_0 on 2023-06-20)
  
  I am trying to create a Civi rule that will be triggered by "Membership is changed" and then set the end date of this membership to a new value. (This rule is needed as a workaround for another bug in how CiviSepa interacts with one-time membership contributions.)
  
  When I create an Action for this rule, I select "Update Date Value", as this seems to be the action most close to what I need (modify end date). I get redirected to a page asking for "Source Field", "Target Field", "Operation" and "Operand". When I click on the down-arrow on the right side of "Source Field" and "Target Field", no drop-down menue is opening. Instead, only a grey line appears when I click, and disappears when I click again.
  The same happens when I select the action "Advanced Update Date Value".
  
  Does anybody know what could be the problem here? I get no error whatsoever.
  The rule has no Conditions and no Delay-Action, it contains nothing but a name and a trigger.
  
  Edit:
  I tested this on a [CiviCRM demo page](https://demo.circle-interactive.co.uk/) running the version 5.62.0. In this demo system, I was able to add a Rule with the trigger "Membership is changed" and the action "Update Date Value". I was able to choose "Start Date" in "Source Field" and "End Date" in "Target Field".
  
  **Tags:** civimember, civirules
  
  > **Comments:**
  > **username_1**: I'm afraid I do not have an answer for you, but I can confirm the behaviour on Civi 5.61 on WordPress. I tried adding a condition, but it made no difference. There don't seem to be any other logical choices for what you are looking for. CiviRule is sometimes a bit arcane, so I may be missing something.  
  > **username_2**: Your "Edit" suggests this is now working on Demo? If so you may just need to upgrade or wait on the next release - or add an Answer yourself to say 'this is now fixed'  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2023-07-01. Score: 1
  
  Membership dates are stored as SQL DATE types, for historic reasons, and most other dates in CiviCRM are stored as an SQL DATETIME. I suspect CiviRules doesn't support DATE, only DATETIME.
  
  So if I'm correct, to fix this, someone would either need to update CiviRules to support DATE or update CiviCRM to use DATETIME for memberships (which probably should be done anyways).
  
  > **Comments:**
  > **username_0**: I checked the date format on the demo system (https://demo.circle-interactive.co.uk/) and here, Membership is also using date values instead of datetime (checked via API). So this cannot be the (only?) problem here.  
  
  ---
  
  