Update table date issue

Questions and Help
1

Trying to update a Data Blaze table date field but getting errors.

{dbselect: SELECT Name, datetimeformat(VacDue, "DD/MM/YY") as VacDue FROM Dogs; space=5vwhNpRFkSJQZTjwT9tdJJ; name=pup; menu=yes}{=pup.name}{=pup.vacdue}
{newdate={time: DD/MM/YY; at={=vacdue}; shift=+1Y}}
{dbupdate: UPDATE Dogs SET Datetimeparse({=vacdue},"DD/MM/YY") = @newdate WHERE Name = "@name"; space=5vwhNpRFkSJQZTjwT9tdJJ; autoaddfields=yes}

2

Hi @tonydow.

There are two issues with your snippet:

  1. SET Datetimeparse({=vacdue},"DD/MM/YY") = @newdate: You cannot use a formula on the left-hand side of the BSQL's UPDATE clause, you should use the name of the column to update instead; so it should be rewritten to: SET vacdue = @newdate.
  2. You should set DD/MM/YY as the pattern for the time command.

Here's the fixed version of your snippet:

{dbselect: SELECT Name, datetimeformat(VacDue, "DD/MM/YY") as VacDue FROM Dogs; space=5vwhNpRFkSJQZTjwT9tdJJ; menu=yes}{=name}{=vacdue}
{newdate={time: DD/MM/YY; at={=vacdue}; shift=+1Y; pattern=DD/MM/YY}}

{dbupdate: UPDATE Dogs SET vacdue = @newdate WHERE Name = @name; space=5vwhNpRFkSJQZTjwT9tdJJ; autoaddfields=yes}

3

That's great thanks