flagged end of the month

[Eugenio211]

Hello,

I have the below data set and wanted to flagged end of the month, can I ask for help?

thanks a lot.

count	date	source
98171	01Jan2022	CA
15394	01Jan2022	LD
15395	02Jan2022	LD
98076	02Jan2022	CA
15383	03Jan2022	LD
98054	03Jan2022	CA
15410	04Jan2022	LD
97828	04Jan2022	CA
15447	05Jan2022	LD
97835	05Jan2022	CA
15433	06Jan2022	LD
97796	06Jan2022	CA
15441	07Jan2022	LD
97809	07Jan2022	CA
97765	08Jan2022	CA
15496	08Jan2022	LD
15511	09Jan2022	LD
97785	09Jan2022	CA
15537	10Jan2022	LD
97766	10Jan2022	CA
15565	11Jan2022	LD
97695	11Jan2022	CA
15592	12Jan2022	LD
97670	12Jan2022	CA
15617	13Jan2022	LD
97688	13Jan2022	CA
97694	14Jan2022	CA
15647	14Jan2022	LD
15659	15Jan2022	LD
97696	15Jan2022	CA
97678	16Jan2022	CA
15669	16Jan2022	LD
15669	17Jan2022	LD
97682	17Jan2022	CA
15673	18Jan2022	LD
97620	18Jan2022	CA
15683	19Jan2022	LD
97550	19Jan2022	CA
15692	20Jan2022	LD
97512	20Jan2022	CA
15709	21Jan2022	LD
97508	21Jan2022	CA
15740	22Jan2022	LD
97494	22Jan2022	CA
15762	23Jan2022	LD
97483	23Jan2022	CA
15779	24Jan2022	LD
97405	24Jan2022	CA
15784	25Jan2022	LD
96809	25Jan2022	CA
15798	26Jan2022	LD
96757	26Jan2022	CA
96783	27Jan2022	CA
15835	27Jan2022	LD
96780	28Jan2022	CA
15852	28Jan2022	LD
15871	29Jan2022	LD
96770	29Jan2022	CA
15883	30Jan2022	LD
96754	30Jan2022	CA
15889	31Jan2022	LD
96741	31Jan2022	CA
96651	01Feb2022	CA
15899	01Feb2022	LD
15924	02Feb2022	LD
96676	02Feb2022	CA
15925	03Feb2022	LD
96699	03Feb2022	CA
15951	04Feb2022	LD
96725	04Feb2022	CA
15986	05Feb2022	LD
96477	05Feb2022	CA
15996	06Feb2022	LD
96399	06Feb2022	CA
15998	07Feb2022	LD
96364	07Feb2022	CA
16022	08Feb2022	LD
96306	08Feb2022	CA
16052	09Feb2022	LD
96293	09Feb2022	CA
16081	10Feb2022	LD
96309	10Feb2022	CA
16099	11Feb2022	LD
96331	11Feb2022	CA
16131	12Feb2022	LD
96349	12Feb2022	CA
16142	13Feb2022	LD
96378	13Feb2022	CA
16128	14Feb2022	LD
96372	14Feb2022	CA
16147	15Feb2022	LD
96356	15Feb2022	CA
16191	16Feb2022	LD
96341	16Feb2022	CA
16223	17Feb2022	LD
96336	17Feb2022	CA
16255	18Feb2022	LD
96327	18Feb2022	CA
16266	19Feb2022	LD
96344	19Feb2022	CA
16285	20Feb2022	LD
96337	20Feb2022	CA
16270	21Feb2022	LD
96278	21Feb2022	CA
16263	22Feb2022	LD
96173	22Feb2022	CA
16311	23Feb2022	LD
96198	23Feb2022	CA
16322	24Feb2022	LD
96229	24Feb2022	CA
16330	25Feb2022	LD
96272	25Feb2022	CA
16353	26Feb2022	LD
96265	26Feb2022	CA
16383	27Feb2022	LD
96285	27Feb2022	CA
16396	28Feb2022	LD
96127	28Feb2022	CA
16417	01Mar2022	LD
95795	01Mar2022	CA
16444	02Mar2022	LD
95841	02Mar2022	CA
16432	03Mar2022	LD
95858	03Mar2022	CA
16436	04Mar2022	LD
95869	04Mar2022	CA
95891	05Mar2022	CA
16463	05Mar2022	LD
16484	06Mar2022	LD
95922	06Mar2022	CA
16496	07Mar2022	LD
95858	07Mar2022	CA
16494	08Mar2022	LD
95667	08Mar2022	CA
16523	09Mar2022	LD
95683	09Mar2022	CA
16560	10Mar2022	LD
95712	10Mar2022	CA
16587	11Mar2022	LD
95726	11Mar2022	CA
16623	12Mar2022	LD
95715	12Mar2022	CA
16626	13Mar2022	LD
95726	13Mar2022	CA
16638	14Mar2022	LD
95704	14Mar2022	CA
16668	15Mar2022	LD
95653	15Mar2022	CA
16694	16Mar2022	LD
95656	16Mar2022	CA
16715	17Mar2022	LD
95683	17Mar2022	CA
16723	18Mar2022	LD
95698	18Mar2022	CA
16762	19Mar2022	LD
95734	19Mar2022	CA
16783	20Mar2022	LD
95754	20Mar2022	CA
16790	21Mar2022	LD
95707	21Mar2022	CA
16807	22Mar2022	LD
95558	22Mar2022	CA
16826	23Mar2022	LD
95576	23Mar2022	CA
16821	24Mar2022	LD
95580	24Mar2022	CA
16851	25Mar2022	LD
95653	25Mar2022	CA
16872	26Mar2022	LD
95716	26Mar2022	CA
16881	27Mar2022	LD
95726	27Mar2022	CA
16904	28Mar2022	LD
95629	28Mar2022	CA
16928	29Mar2022	LD
95538	29Mar2022	CA
16902	30Mar2022	LD
95559	30Mar2022	CA
16837	31Mar2022	LD
95538	31Mar2022	CA
16827	01Apr2022	LD
95583	01Apr2022	CA
16870	02Apr2022	LD
95658	02Apr2022	CA
16891	03Apr2022	LD
95695	03Apr2022	CA
16907	04Apr2022	LD
95663	04Apr2022	CA
16927	05Apr2022	LD
95620	05Apr2022	CA
16891	06Apr2022	LD
95588	06Apr2022	CA
16895	07Apr2022	LD
95585	07Apr2022	CA
16918	08Apr2022	LD
95617	08Apr2022	CA
16944	09Apr2022	LD
95592	09Apr2022	CA
16955	10Apr2022	LD
95627	10Apr2022	CA
16951	11Apr2022	LD
95593	11Apr2022	CA
16973	12Apr2022	LD
95516	12Apr2022	CA
17002	13Apr2022	LD
95509	13Apr2022	CA
17025	14Apr2022	LD
95517	14Apr2022	CA
17048	15Apr2022	LD
95581	15Apr2022	CA
17050	16Apr2022	LD
95572	16Apr2022	CA
17067	17Apr2022	LD
95613	17Apr2022	CA
17080	18Apr2022	LD
95557	18Apr2022	CA
17120	19Apr2022	LD
95506	19Apr2022	CA
17146	20Apr2022	LD
95504	20Apr2022	CA
17155	21Apr2022	LD
95529	21Apr2022	CA
17191	22Apr2022	LD
95576	22Apr2022	CA
17220	23Apr2022	LD
95628	23Apr2022	CA
17228	24Apr2022	LD
95693	24Apr2022	CA
17219	25Apr2022	LD
95688	25Apr2022	CA
17237	26Apr2022	LD
95562	26Apr2022	CA
17255	27Apr2022	LD
95556	27Apr2022	CA
17297	28Apr2022	LD
95573	28Apr2022	CA
17327	29Apr2022	LD
95621	29Apr2022	CA
17349	30Apr2022	LD
95669	30Apr2022	CA
17361	01May2022	LD
95710	01May2022	CA
17364	02May2022	LD
95686	02May2022	CA
17386	03May2022	LD
95639	03May2022	CA
17381	04May2022	LD
95625	04May2022	CA
17387	05May2022	LD
95687	05May2022	CA
17417	06May2022	LD
95713	06May2022	CA
17459	07May2022	LD
95644	07May2022	CA
95668	08May2022	CA
17476	08May2022	LD
17468	09May2022	LD
95645	09May2022	CA
17490	10May2022	LD
95577	10May2022	CA
17532	11May2022	LD
95607	11May2022	CA
17546	12May2022	LD
95656	12May2022	CA
17581	13May2022	LD
95713	13May2022	CA
17606	14May2022	LD
95808	14May2022	CA
17622	15May2022	LD
95856	15May2022	CA
17640	16May2022	LD
95852	16May2022	CA
17691	17May2022	LD
95807	17May2022	CA
17722	18May2022	LD
95827	18May2022	CA
17761	19May2022	LD
95855	19May2022	CA
17785	20May2022	LD
95918	20May2022	CA
17812	21May2022	LD
96020	21May2022	CA
17827	22May2022	LD
96063	22May2022	CA
17816	23May2022	LD
96035	23May2022	CA
17845	24May2022	LD
95846	24May2022	CA
17871	25May2022	LD
95909	25May2022	CA
17904	26May2022	LD
95974	26May2022	CA
17939	27May2022	LD
96106	27May2022	CA
17971	28May2022	LD
96217	28May2022	CA
17983	29May2022	LD
96257	29May2022	CA
18018	30May2022	LD
96267	30May2022	CA
18055	31May2022	LD
96271	31May2022	CA
18084	01Jun2022	LD
96393	01Jun2022	CA
18122	02Jun2022	LD
96488	02Jun2022	CA
18163	03Jun2022	LD
96598	03Jun2022	CA
18168	04Jun2022	LD
96709	04Jun2022	CA
18183	05Jun2022	LD
96729	05Jun2022	CA
18185	06Jun2022	LD
96617	06Jun2022	CA
18232	07Jun2022	LD
96542	07Jun2022	CA
18261	08Jun2022	LD
96578	08Jun2022	CA
18305	09Jun2022	LD
96633	09Jun2022	CA
18344	10Jun2022	LD
96756	10Jun2022	CA
18382	11Jun2022	LD
96863	11Jun2022	CA
18403	12Jun2022	LD
96925	12Jun2022	CA
18426	13Jun2022	LD
96905	13Jun2022	CA
18445	14Jun2022	LD
96866	14Jun2022	CA
18490	15Jun2022	LD
96918	15Jun2022	CA
18518	16Jun2022	LD
96996	16Jun2022	CA
18529	17Jun2022	LD
97053	17Jun2022	CA
18566	18Jun2022	LD
97163	18Jun2022	CA
18590	19Jun2022	LD
97229	19Jun2022	CA
18606	20Jun2022	LD
97054	20Jun2022	CA
18654	22Jun2022	LD
97187	22Jun2022	CA
18674	23Jun2022	LD
97298	23Jun2022	CA
18681	24Jun2022	LD
97401	24Jun2022	CA
18693	25Jun2022	LD
97502	25Jun2022	CA
18707	26Jun2022	LD
97423	26Jun2022	CA
18715	27Jun2022	LD
97407	27Jun2022	CA
18739	28Jun2022	LD
97361	28Jun2022	CA
18791	29Jun2022	LD
97437	29Jun2022	CA
18814	30Jun2022	LD
97510	30Jun2022	CA
18832	01Jul2022	LD
97676	01Jul2022	CA
18855	02Jul2022	LD
97687	02Jul2022	CA
18893	03Jul2022	LD
97703	03Jul2022	CA
18906	04Jul2022	LD
97665	04Jul2022	CA
18915	05Jul2022	LD
97393	05Jul2022	CA
18915	06Jul2022	LD
97403	06Jul2022	CA
18951	07Jul2022	LD
97454	07Jul2022	CA
18989	08Jul2022	LD
97499	08Jul2022	CA
19013	09Jul2022	LD
97511	09Jul2022	CA
19029	10Jul2022	LD
97549	10Jul2022	CA
19047	11Jul2022	LD
97522	11Jul2022	CA
19050	12Jul2022	LD
97424	12Jul2022	CA
19074	13Jul2022	LD
97448	13Jul2022	CA
19077	14Jul2022	LD
97477	14Jul2022	CA
19099	15Jul2022	LD
97499	15Jul2022	CA
19128	16Jul2022	LD
97526	16Jul2022	CA
19147	17Jul2022	LD
97553	17Jul2022	CA
19149	18Jul2022	LD
97538	18Jul2022	CA
19146	19Jul2022	LD
97454	19Jul2022	CA
19165	20Jul2022	LD
97464	20Jul2022	CA
19183	21Jul2022	LD
97538	21Jul2022	CA
19206	22Jul2022	LD
97598	22Jul2022	CA
19240	23Jul2022	LD
97667	23Jul2022	CA
19259	24Jul2022	LD
97697	24Jul2022	CA
19268	25Jul2022	LD
97642	25Jul2022	CA
19297	26Jul2022	LD
97448	26Jul2022	CA
19322	27Jul2022	LD
97474	27Jul2022	CA
19330	28Jul2022	LD
97538	28Jul2022	CA
19343	29Jul2022	LD
97648	29Jul2022	CA
19390	30Jul2022	LD
97755	30Jul2022	CA
19401	31Jul2022	LD
97772	31Jul2022	CA
19385	01Aug2022	LD
97727	01Aug2022	CA
19363	02Aug2022	LD
97604	02Aug2022	CA
19398	03Aug2022	LD
97701	03Aug2022	CA
19401	04Aug2022	LD
97784	04Aug2022	CA
19399	05Aug2022	LD
97836	05Aug2022	CA
19449	06Aug2022	LD
97782	06Aug2022	CA
19462	07Aug2022	LD
97777	07Aug2022	CA
19439	08Aug2022	LD
97751	08Aug2022	CA
19459	09Aug2022	LD
97700	09Aug2022	CA
19469	10Aug2022	LD
97717	10Aug2022	CA
19479	11Aug2022	LD
97745	11Aug2022	CA
19476	12Aug2022	LD
97771	12Aug2022	CA
19490	13Aug2022	LD
97808	13Aug2022	CA
19498	14Aug2022	LD
97831	14Aug2022	CA
19473	15Aug2022	LD
97785	15Aug2022	CA

[PeterClemmensen]

So simply a flag that is = 1 when the date is the last day of the month?

[Eugenio211]

yes, my goal is just to get all the last day of the month. thanks.

[kelxxx]

if date = intnx('month',date,1)-1;

 or

if date = intnx('month',date,0,'E');