Developer forum

Forum » PIM » Custom group field with current date as value - updated daily

Custom group field with current date as value - updated daily

Davy Capiau
Reply

Hi,

Is there a way to render the value of the current date in a custom group field without having to use database operations? It has to update daily.

Similiar like we use DateTime.now in queries (check screenshot)


Replies

 
Søren Jensen Dynamicweb Employee
Søren Jensen
Reply

Hi Davy,

I do not know in which context you want to use this information.

But the function "DateTime" are used in Queries, to search/filtering products out from a relative dateTime.

You could use a schedulleTask (SQL), to set the DateTime value, once per day.

I dont know if that would help you.

/Søren

 
Davy Capiau
Reply

Hi Soren,

As a custom group field, a custom attribute on a group.

I wanted to know if i could do it without SQL

Kr

 
Søren Jensen Dynamicweb Employee
Søren Jensen
Reply

Hi Davy,

If you want the value updated once per day, I believe you need to make it done from a scheduled task. 

You can use our "SQL add-in", to run the SQL command.

/Søren

 

You must be logged in to post in the forum