robmarr789
Contributor
2019-05-24
03:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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'))
811 Views
1 Solution
Accepted Solutions
tresesco
MVP
2019-05-24
04:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try like:
='Sales £ all ' & min({TEST}date((PostingDate),'DD/MM/YY'))&'-'&Max({TEST}date(PostingDate,'DD/MM/YY'))
808 Views
1 Reply
tresesco
MVP
2019-05-24
04:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try like:
='Sales £ all ' & min({TEST}date((PostingDate),'DD/MM/YY'))&'-'&Max({TEST}date(PostingDate,'DD/MM/YY'))
809 Views