I want to execute a DateDiff function in a collection. The calculation is also successful, but I don't succeed in displaying it correctly in a DataTable or Gallery. Although the correct value (e.g. 5) is displayed in the code, a 0 is displayed in the gallery.
Patch(
CollectionName;
Last(CollectionName);
{
Hours: DateDiff(
Last(CollectionName).Start;
Last(CollectionName).End;
Hours
)
}
)In the meantime I have tried out some possibilities and even deleted the collection and completely rebuilt it, but I just don't know where the problem is. Maybe someone has an idea and can help me.