Update a Date coluum using Patch fuction

[JasonCastro]

I need to change the DateColuum only when a certain option is selected.

In the code below I get the value of the combobox in a variable and then I try to insert it in the ID of that data

When I put the" varBoxAtm" variable in the Patch function, it is understood as a "Record" type and not as a Date".

If(comboBoxAtm.Selected.Value = "Foo";
Set(varBoxAtm; Now()));;

Patch(
    TBL_INFO;
    {
       DateColuum:   {
                        ID: emergencyGallery.Selected.ID;
                        Value: varBoxAtm;
              }        
        
    }
);;

[RandyHayes · Accepted solution]

@JasonCastro 

Yes...you are setting the entire column to a record.  Your syntax is not correct.

Please consider changing your Formula to the following:

If(comboBoxAtm.Selected.Value = "Foo";
    Patch(TBL_INFO;
       {
       ID: emergencyGallery.Selected.ID;
       DateColuum:  Now()        
       }
    )
);;

You don't need the variable to do this.  I took it out.  If you happen to need it elsewhere, just add it back.

I hope this is helpful for you.

[JasonCastro]

It's even better without using the IF, thanks!

[RandyHayes]

@JasonCastro 

Excellent!