update only year or have a wild card for year

Got something cool to share with AppGini users? Feel free to post it here!
Post Reply
User avatar
richard
Posts: 15
Joined: 2023-03-22 13:08
Location: Oroville CA
Contact:

update only year or have a wild card for year

Post by richard » 2024-07-11 19:28

I have a holidays table with a date field. I need to update only the year and not the month or day. Is there a way with Mass Update or can I enter a wildcard into the date field that allows only month and date and allows for the current year ?

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1665
Joined: 2018-04-01 10:12

Re: update only year or have a wild card for year

Post by pbottcher » 2024-07-12 08:00

Hi,

not sure what you try to achieve. Do you want to update existing records, or limit the input to existing record to only update the year?
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

Post Reply