Specialist II
2022-06-29
10:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@robstar256 I used below data as sample for my front end evaluation:
NoConcatenate
Temp:
Load * inline [
HIDate
6/27/2022
6/25/2022
6/26/2022
6/23/2022
06/22/2022
];
Exit Script;
Backend Expression in the Straight table:
=if(Date(Date#(HIDate,'MM/DD/YYYY'),'MM/DD/YYYY')=Date('6/27/2022','MM/DD/YYYY'),1,0)
977 Views