I have a Date field (DD/MM/YYYY) and need to convert it to MMYYYY as an integer (ex. 01/31/2012 to 012012) to be used in a comparison with another MMYYYY date.

This message has been edited. Last edited by: Kathleen Butler,

Hi Ted,

  
D1/DMYY='&DMYY';
D2/A8DMYY=D1;
D3/I6L=EDIT(EDIT(D2,'$$999999'));

Thanks, I'll try that.

Since you are dealing with a field in a data record (rather than a parameter value), you can use

alpha_date/A8DMYY=EDIT(date_field,'99$99$9999');
relative_date/DMYY=alpha_date;

relative_date displays as a formatted date in the original format (DD/MM/YYYY), but it can be used to sort records into date order. (Its internal value is the offset, in days, from some standard base date.)