Automatic invoice number

HI Guys, I want to have a column that pull the date and the client firs 3 letters, and then I want to have a extra number in case the date and the client name are the same, to make them different. I tried this but I don’t manage to make the rank different when the client and the date are the same:

Format("{1}{2:00}{3:00}{4}{5}{6}",
thisRow.[Date started].Year().Right(2),
thisRow.[Date started].Month(),
thisRow.[Date started].Day(), ToText("-"),
thisRow.[Client Name].ToText().left(3),
Rank(thisRow.[Date started],[Transactions DB].Filter([Client Name]=thisRow.[Client Name])))

What am I doing wrong?

I really appreciate your help, I’m learning a lot from this community!

Eva Folch

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.