Solved Dater ange

[quest]

Hi
I have report with date field from which i get range with min and max. result is ok for example i get result 2017-2023. problem is that when a range is only one year i get result 2025-2025 for example. how do I get simple value like 2025 only instead of 2025-2025.

 

[theDBguy]

You may have to show us the expression or code you're using to produce the range. I imagine you'll need to add an IF statement or something similar to check the value for duplicate years.

 

[quest]

You may have to show us the expression or code you're using to produce the range. I imagine you'll need to add an IF statement or something similar to check the value for duplicate years.

I use this expression =Min(DatePart("yyyy";[EnterDate])) & "-" & Max(DatePart("yyyy";[EnterDate]))

 

[theDBguy]

I use this expression =Min(DatePart("yyyy";[EnterDate])) & "-" & Max(DatePart("yyyy";[EnterDate]))

That doesn't look right if [EnterDate] is a query parameter, but you can try something like this:

IIf(Min(Year([EnterDate]))=Year(Max([EnterDate])),Year(Max([EnterDate])),Year(Min([EnterDate])) & "-" & Year(Max([EnterDate])))

 

[quest]

EnterDate is the name of field.

 

[Pat Hartman]

You need to make the expression more complex or create a function. I would create a function. Then you could use the min and the max and compare them so you can decide what to return.

 

[theDBguy]

EnterDate is the name of field.

I updated the code above, because I missed to use the Year() function in the other areas. Give it a shot and let us know what happens.

 

[quest]

I got message wrong number of arguments.

 

[quest]

now with correction do not except it all.

 

[quest]

Report is based on query. expression =Min(DatePart("yyyy";[EnterDate])) & "-" & Max(DatePart("yyyy";[EnterDate])) is written in the control source

 

[quest]

I solved it. it shoul be like this IIf(Year(Min([EnterDate]))=Year(Max([EnterDate])),Year(Max([EnterDate])),Year(Min([EnterDate])) & "-" & Year(Max([EnterDate]))). need to switch year and min. thanks

 

[theDBguy]

I solved it. it shoul be like this IIf(Year(Min([EnterDate]))=Year(Max([EnterDate])),Year(Max([EnterDate])),Year(Min([EnterDate])) & "-" & Year(Max([EnterDate]))). need to switch year and min. thanks

Sorry about that but glad to hear you got it sorted out.