Patching or updating dates

[Keit]

Hi

basically i need to check if the date from sharepoint column(ReservedForTomorrow) is equal to todays date and if it is then copy/ that date to other column called ReservedFor. current code that doesn't run

Patch(Filter('Parking - Products'; StartsWith(Text(ReservedForTomorrow); Datenow)); {ReservedFor:Today()+23})

DateNow is a variable with todays date

i'm not a proffesional in this area and have been trying to fix it for days 😞

[CNT]

@Keit Try this,

Patch('Parking - Products', LookUp('Parking - Products', ReservedForTomorrow=Today()), {ReservedFor:Today()+23})

[Keit]

sadly that didn't update that reservedfor 

[CNT]

@Keit what datatypes are ReservedForTomorrow & ReservedFor?

[Keit]

date and time 

[CNT]

@Keit Try setting it to Date Only

[Keit]

Thanks this worked, had to change the date codes on all screens.

another question how would i be able to patch text columns that conatin emails too, code that i tried below didn't accept it

Patch('Parking - Products', LookUp('Parking - Products', ReservedForTomorrow=Today()), {ReservedFor:Today()};{reservedbytomorrow:reservedby})

[CNT]

@Keit when you want to patch multiple fields, separate them with a comma,

Patch('Parking - Products', LookUp('Parking - Products', ReservedForTomorrow=Today()), {ReservedFor:Today(), reservedbytomorrow:reservedby})

Please remember to give a 👍 and accept the solution as it will help others in the future.

[Keit]

the last one only lets me choose datacards not the column value

[CNT]

@Keit I'm not quite sure what you mean by that. If you have a TextInput that has the email, you will have to write, my TextInput.Text

Hope that helps.