Calculate Start Date and Time

[patcccc]

Hi...

I am looking for a business function (C or NER) that will take as input the End Date, End Time and Duration. It must return me the Start Date and Time. Does such fuunction exists in JDE?

Thanks for your help.

 

[DBohner-(db)]

I'll have to look for such a function - but, don't forget that you can use negatives - when using date/time functions. Thus, you will get a similar affect.

Daniel

 

[kstern]

There is no single business function to do this. What you need to do is use
BSFN B9800009, "Get UTC Time" to convert the End Date and Time into the UTC
value. This value is returned as minutes, the documentation for the BSFN says
seconds but that is wrong. Then take the duration convert it into minutes and
subtract it from the returned value from the above BSFN. Then use BSFN
B9800009, "Get Time and Date From UTC" to format the UTC time into Date and Time.

Ken Stern
Sr. Consultant
Ciber, Inc.

 

[Mali]

I am trying to get the No of days & hrs between two days.

What is the best way to do that?
Tried the BSFN GET UTC TIME & got the difference between the two. But that is not correct.

Any help.........

 

[Mali]

BSFN GET UTC TIME & got the difference between the two
worked fine, was looking ata different record earlier