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