Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone, I would like to have the number of contracts created in 2023. However, the contract creation date ( DateCreation) is in Timestamp format. I have converted
You'll see my code below:
Count({$<[Client.statusresil]= {'false'},date#(floor([Client.datecreation]))={"> 31/12/2022"}>} distinct [Client.id_client])
I've tested the above code and it doesn't work. The result is the following capture:
Could you please help me?
Thanks in advance
Have a nice day
try:
Count({$<[Client.statusresil]= {'false'},Date(floor(Date#([Client.datecreation])),'DD/MM/YYYY')={"> 31/12/2022"}>} distinct [Client.id_client])
I tried but it's always the same result