Getting last record of a field in textbox

[Anonymous]

Hi,

I have a requirement for displaying the last value of the listbox in a text object.

The listbox have date range values. I tried max(Week-range) but it is not working.

I have attached the screenshot of date field for reference.

Thanks for your help in advance.

[Anil_Babu_Samineni]

Can you use MaxString instead of Max?

[YoussefBelloum · Accepted solution]

Hi,

procede like this:

Create a Variable (vVariables, for example)

=MaxString(Week_range)

on your listbox, try this:

=if(Week_range=vVariable, Week_range)

[Anonymous]

Oh thank you. It worked.

can you please tell me how to get the last before value also

[alis2063]

I have tried but did not work around.

if(Week_Range=vVariable, Week_Range)

I am getting result but its not listed & performing at header as below,

Use as below

=MaxString(Week_Range)

[YoussefBelloum]

Can you attach your app here please?

[YoussefBelloum]

Hi stalwar1‌ can you help on this please? to get the Before last value.. maybe starting with the solution I provided here

Thank you

[alis2063]

pfa

[tamilarasu]

Hello,

Not tested but try this and let us know.

MaxString({<Week_Range-={"$(=Maxstring(Week_Range))"}>}Week_Range)

[sunny_talwar]

I think this might have already been resolved

Last before value in textbox