Issues with MinString and Strings with lower/upper cases

[EliGohar]

Hi all,

Using the following expression I'm trying to get the first source (ABC order) with the maximum date (with a URL that is not null):

MinString({<Date={"<=$(=Date(Max(Date),'DD/MM/YYYY'))"}, [Dwell_Heat_Map_URL]-={"-"}>} Source)

This is the list of sources I have

What I get in that case is Camera1112, which is not the min string. I suppose to get airport1 source.

I guess it's something to do with Upper and lower cases.

Can you advise me how to overcome this issue?

Thanks 🙂

[sunny_talwar]

One option is to use this

MinString({<Date={"<=$(=Date(Max(Date),'DD/MM/YYYY'))"}, [Dwell_Heat_Map_URL]-={"-"}>} Capitalize(Source))

[EliGohar]

Hi @sunny_talwar 

Tried this , and also Upper() or Lower().

This options ignore the conditions i set in the set analysis for some reason.

It's bringing me the First Source in ABC order, but that source doesn't have the max date.

Here's a screenshot:

Maybe you can think about another solution?

Thanks!

[sunny_talwar]

This is an issue with the set analysis on Date... is your date formatted as DD/MM/YY or DD/MM/YYYY? If it is DD/MM/YY, try this

MinString({<Date={"<=$(=Date(Max(Date),'DD/MM/YY'))"}, [Dwell_Heat_Map_URL]-={"-"}>} Capitalize(Source))

[EliGohar]

Not working 😞
the date is DD/MM/YYYY

[sunny_talwar]

Are you changing the format from the Number's tab here?

Can you check the default format by creating a list box for Date field without any functions

[EliGohar]

Original format is DD/MM/YY

When i'm using this expression it gives me the maximum date:

MinString({<Date={"<=$(=Date(Max(Date),'DD/MM/YYYY'))"}, [Common_Path_URL]-={"-"}>} Capitalize(Source)) & ' ' &  max({<Date={"<=$(=Date(Max(Date),'DD/MM/YYYY'))"}, [Common_Path_URL]-={"-"}>}Date)

but again, i get the wrong source name 😞

I still suspect that using the Capitalize function ignores the set analysis rules.

[sunny_talwar]

Oh, I see what is going on... you need this on the Max Date.... Try this

MinString({<Date={"$(=Date(Max(Date),'DD/MM/YYYY'))"}, [Common_Path_URL]-={"-"}>} Capitalize(Source))

Basically, you were looking at MinString on all Dates less than the max date, but it seems you need the MinString on the Max Date itself. Is that right?

[EliGohar]

---

@sunny_talwar wrote:

Oh, I see what is going on... you need this on the Max Date.... Try this

MinString({<Date={"$(=Date(Max(Date),'DD/MM/YYYY'))"}, [Common_Path_URL]-={"-"}>} Capitalize(Source))

Basically, you were looking at MinString on all Dates less than the max date, but it seems you need the MinString on the Max Date itself. Is that right?

---

Yes, That's exactly what I intended to achieve.

However, the correction you posted isn't bringing any result.

[sunny_talwar]

Would you be able to share a sample of your app to show the issue?