LASTFULLMONTH

[Former Member]

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

[abhilash_kumar · Accepted solution]

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

[Former Member · Accepted solution]

I was thinking of another way and that i would learn a new thing.

SUppose i run a cr daily and get the current date address and place it in a global variable. that i can use in programs later on.

But i never used global variable, is there some example.