Date Substration

[greeki78]

Dear All,
I have to create a formula to get date 7 days back from today's date.For example ,today's date is Sept 02.So I have to subtract 7 days from it and get the date 26th Aug.

Regards,
Greg

 

[Manturo]

Try today - 7 and see if that works.

 

[greeki78]

It tried,it didn't work

 

[TomBascom]

This does indeed work:

display today - 7.

It is basic Progress 4GL Programming 101.

You need to post some sample code that illustrates whatever it is that isn't working for you.

 

[mirekpa]

Hi
If you use the buffer object (buffer_hand::data_field),
to subtract is necessary cast this object to date.

M.

 

[greeki78]

I am using epicor which uses progress database.So I am creating a calculated field in epicor where I have to substract 7 days from today's date.

Regards,
Greg

 

[TomBascom]

How do you create this calculated field?

(If this is specific to Epicor's software you would probably be better off asking them...)