Required last Posting date on the basis of month

[Maheshp]

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 Date	Doc. Date	Entry Date	DocumentNo
08/01/2025	08/31/2025	08/29/2025	56000106
08/01/2025	08/31/2025	08/29/2025	56000106
08/01/2025	08/31/2025	08/29/2025	56000106
08/01/2025	08/31/2025	08/29/2025	56000106
08/31/2025	08/31/2025	08/29/2025	56000106
08/31/2025	08/31/2025	08/29/2025	56000106
08/31/2025	08/31/2025	08/29/2025	56000106

Regards,

Mahesh

[JosephSerpis · Accepted solution]

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.

[dreldrel]

You can also use DateTimeDiff to minus 1 day from the start date of the month