current month

[raadwiptec]

hi all,

I have a column named opening date for ex:

Temp2:

Load

[invoice no,]

[Opening date],

Charges

Quantity

Resident temp1;

store  temp2 into C;/.......qvd

i need to have opening dates only  for previous month..

As iam storing only in QVD ... i will nt be using any fron end expressions ...

nbeed solution on script level?

kindly suggest..

[Mark_Little]

HI,

Check that you date format is set correct on the main tab.

SET DateFormat='DD/MMM/YYYY';

OR

MONTH(DATE(ADDMONTHS(TODAY(),-1),'DD/MMM/YYYY')) in the where,

Any doubts, add text boxes in the UI and see what the functions return and make sure they are like for like.

Mark