I know this is a super easy question and I'm almost so embarrased to ask but how do I convert the current date (TODAY()) into a format where I can do computations on it (i.e. Date comparisons using LE, GE etc...). Every thing I'm reading is saying the output is A8 and we all know that this will abend as soon as I do a computations with it. There has to be a way to Define it other than alphanumeric. Thanks

Dennis,

There are many date &variables which you can find in the manual. Here are a few:
Numeric
&YMD, &DMY, &MYD
&YYMD, &DMYY, &MDYY

With slashes:
&DATEYMD, &DATEDMY, &DATEMDY
&DATEYYMD, &DATEDMYY, &DATEMDYY

Etc. etc. etc.

Dennis,

The answer will depend on where you want to do the caluculations. Are you wanting to do them in a DEFINE, Dialogue Manager, Maintain or MODIFY?

TODAX/MDY = &MDY;
TODAY/MDYY = TODAX + 36525;
LATE/MDYY = INVDATE + 30;
MONTH/I2 = (TODAY - LATE)/30;
CURMO/M = TODAY;
CURDA/D = TODAY
CURYR/YY = TODAY;

More examples.
Kent

If you want the current Date and Time, you could use HGETC

DateTime/HYYMDm = HGETC(10, 'HYYMDm');

As jgelona said, what do you want to do with it ?

Hi Jgelona, Thanks for the response. I'm wanting to do this in the Define section. Thanks!

quote:

Originally posted by jgelona:
Dennis,

The answer will depend on where you want to do the caluculations. Are you wanting to do them in a DEFINE, Dialogue Manager, Maintain or MODIFY?

Thanks Danny!!! Your information was greatly appreciated!!

quote:

Originally posted by Danny-SRL:
Dennis,

There are many date &variables which you can find in the manual. Here are a few:
Numeric
&YMD, &DMY, &MYD
&YYMD, &DMYY, &MDYY

With slashes:
&DATEYMD, &DATEDMY, &DATEMDY
&DATEYYMD, &DATEDMYY, &DATEMDYY

Etc. etc. etc.

Thanks KentO for answering my question. Have a great day!!

quote:

Originally posted by KentO:
TODAX/MDY = &MDY;
TODAY/MDYY = TODAX + 36525;
LATE/MDYY = INVDATE + 30;
MONTH/I2 = (TODAY - LATE)/30;
CURMO/M = TODAY;
CURDA/D = TODAY
CURYR/YY = TODAY;

More examples.
Kent

Hi Waz, I was trying to write code to query all records created within the last week (7days) and this job would be executed within Report Caster and automatically emailed to the customer. Unfortunately all my dates are in a datetime format; thus, I need to first truncate the time before I start calculating to figure out which records were created within the last week. Thanks for responding to my question!!

quote:

Originally posted by Waz:
If you want the current Date and Time, you could use HGETC

DateTime/HYYMDm = HGETC(10, 'HYYMDm');

As jgelona said, what do you want to do with it ?

Dennis,

If I understand you correctly, you have a date fielf - let's call it DATEF - which has a datetime format and you want it to be greater than today - 7 days. You could to the following:

  
-SET &DAY7=AYMD(&YYMD, -7, 'I8YYMD');
-SET &DT7=&DAY7 | ' 00:00:01';

in your TABLE:

WHERE DATEF GT DT(&DT7);

Dennis, there are several ways to do what you want.

As long as you have the start and end dates, this is easy.
Here are some suggestions

• Create a where clause using the DT function
  
• If your source data is relational, add an extra line to the master defining the datetime field as a date (e.g. Usage:YYMD Actual: DATE), then use normal where clause to get the range
  
• Using a DEFINE convert the datetime field to DATE (Use function HDATE), then test against this field.
  

I would suggest the first option as it will be more efficient.

e.g.

WHERE DT_FIELD GE DT(&Startdate 00:00AM)
WHERE DT_FIELD LT DT(&Enddate 00:00AM)

The & Dates are in the format YYMD.

This message has been edited. Last edited by: Waz,