This content has been marked as final.
Show 3 replies
-
1. Re: How to select latest record
Luciano Vasconcelos Jul 13, 2016 7:17 AM (in response to Kian Hee Leow)Check if works to you.
-
Book1.twbx 16.7 KB
-
-
2. Re: How to select latest record
John Sobczak Jul 13, 2016 7:27 AM (in response to Kian Hee Leow)1 of 1 people found this helpfulMaybe this?: right(str({fixed [ID]: max([Modified Date Integer + Contact Integer])}),6)
where [Modified Date Integer + Contact Integer] = int([date])*100000 + int([Contact])
-
3. Re: How to select latest record
Luciano Vasconcelos Jul 13, 2016 7:43 AM (in response to Kian Hee Leow)This works.
-
Book1 (2).twbx 17.9 KB
-