I am trying to count the days a technician has finished a job within a period. Below is an example where it works fine. Finishing Date is formatted DD-MM-YYYY
NL("CountUnique";"Service Item Line Archive";"Finishing Date";"Resource Code Allocated";"<technician>";"Finishing Date";"<period>")
We are now using another database where the Finishing Date is database field that contains both date and time. Formatted DD-MM-YYYY HH:MM:SS
I need to somehow count the unique existence of only the datepart. I can't change the field in the DB
When i use both date and time all Finishing Dates differ and i do not accomplish what i want.
I guess that i somehow need to manipulate Finishing Date into date only.
/Casper