0

Switching to next year

Hello everyone, I hope you're all well! I don't know if this question is already asked, but here's the deal: I have a table containing 2 fields-1 text field and 1 date field. It shows the dates of the "name day" for each name. I would like this table to refresh every new year, so if a name has its name day on November 11, 2022, I want to be able with a single action replace the date to November 11, 2023 and so on! is there a way to do that?

Thank you so much in advance.

Best regards

9replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • pirinisz
    • pirinisz
    • 9 mths ago
    • Reported - view

    Also, one more thing: I want these 2 fields to be imported in another table, where I already put a field (name) that I choose from the 1st field, but I want to auto insert the date field on the same record! Any suggestions on that??

    Like
    • pirinisz
    • pirinisz
    • 9 mths ago
    • Reported - view

    Scratch the 2nd question, I found out how to do that! I just need help with the year replacement from the 1st question!

    Thanks you guys!

    Like
    • Lars
    • Lars
    • 9 mths ago
    • Reported - view

    The formula update the datefield is

    if today() > datefield then
        datefield := date(year(today())+1, month(datefield), day(datefield))
    end;
    
    Like 1
      • pirinisz
      • pirinisz
      • 9 mths ago
      • Reported - view

      Lars You mean I should create a formula field within the table or put this code in the date field???

      Like
      • pirinisz
      • pirinisz
      • 9 mths ago
      • Reported - view

      Lars I also noticed that this works with any new record I create, but what about the old records? Will they auto refresh somehow or should I do something about it?

      Thank you so much for this info!

      Like
      • Fred
      • Fred
      • 9 mths ago
      • Reported - view

      If you want to affect all records in table you have options:

      1) You can select update multiple records under the Gear icon and then select Assign Calculated value then put this in the formula:

      datefieldname + 365
      

      Then click OK. Then click Next and you will see what value Ninox will put in the date field.

      2) You can create a button that you press once a year. You can put this in the On Click field:

      for loop1 in select TableName do
      loop1.(DateFieldName := DateFieldName + 365)
      end
      

      But be careful with this because this will change all records in your table.

      Like
      • pirinisz
      • pirinisz
      • 9 mths ago
      • Reported - view

      Fred One other option I thought about is adding the code you sent me:

      if today() > datefield then
          datefield := date(year(today())+1, month(datefield), day(datefield))
      end;
      to the "Trigger after open" field of the database options:

      I just don't know how to refer to the specific table, because this: if today() > datefield then

      is not enough to trigger, we need to tell it in which table the field is located!!!

      Like
    • John Halls
    • John_Halls
    • 9 mths ago
    • Reported - view

    You are correct, if you put it in the Trigger after open: then it needs to know the table and records, so change the code to something like this

    for a in select tablename where today() > datefield do
        a.datefield := date(year(today())+1, month(a.datefield), day(a.datefield))
    end;
    

    Regards John

    Like 1
      • pirinisz
      • pirinisz
      • 9 mths ago
      • Reported - view

      John Halls Worked like a charm! Thank you so much! You made me happy!! 😄

       

      Best regards

      Like
Like Follow
  • 9 mths agoLast active
  • 9Replies
  • 49Views
  • 4 Following