Required last Posting date on the basis of month

Question

Hi Team,

I have two pstng dates in the output file (08/01/2025 & 08/31/2025) but i want only last day of the month, some month would be 30. so how can i put the Filter.

Pstng DateDoc. DateEntry DateDocumentNo08/01/202508/31/202508/29/20255600010608/01/202508/31/202508/29/20255600010608/01/202508/31/202508/29/20255600010608/01/202508/31/202508/29/20255600010608/31/202508/31/202508/29/20255600010608/31/202508/31/202508/29/20255600010608/31/202508/31/202508/29/202556000106

Regards,

Mahesh

aaa.xlsx

JosephSerpis · Accepted Answer

Hi @Maheshp you can use the formula DateTimeTrim using the arguement lastofmonth. Your date field will need to be ISO format e.g YYYY-MM-DD to utlise this formula within a filter for example.