Skip to Content
avatar image
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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 22, 2015 at 12:33 AM

    Hi Paul,


    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


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.