Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

LASTFULLMONTH

HI I would like to use Lastfullmonth.

I would like to process for the previous month on the 2nd of each new month. Giving only the invoiced orders from prev month.

How do i use this feature, my date is number, YYYYMMDD

Former Member
replied

Hi Paul,

Try:

CDate(Picture({Number_field}, 'xxxx/xx/xx')) IN LastFullMonth

Do note that this will not translate to where clause. You should use a SQL Expression to convert the number field to Date using database specific functions.

You can then use a Record Selection that looks like:

{%SQL Expression} IN LastFullMonth

-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question