Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
robmarr789
Contributor
Contributor

use alternate state in label

Can any one tell me how I would edit this label expression so that it uses the date selections from an alternate state

 

The alternate state is called TEST

 

='Sales £ all ' & min(date((PostingDate),'DD/MM/YY'))&'-'&Max(date(PostingDate,'DD/MM/YY'))

Labels (3)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:
='Sales £ all ' & min({TEST}date((PostingDate),'DD/MM/YY'))&'-'&Max({TEST}date(PostingDate,'DD/MM/YY'))

View solution in original post

1 Reply
tresesco
MVP
MVP

Try like:
='Sales £ all ' & min({TEST}date((PostingDate),'DD/MM/YY'))&'-'&Max({TEST}date(PostingDate,'DD/MM/YY'))