BI Publisher (MOSC)

MOSC Banner

How to subtract a number of days from a date field

edited Jul 16, 2019 9:05AM in BI Publisher (MOSC) 2 commentsAnswered ✓

Hi,

This is for BI Publisher (JDE) in a Microsoft Word template.

I need to get the previous date by subtracting 32 days from the date.

Example: I need to subtract 32 days from 2019-04-30 and return 2019-03-29.

Date Field: <ReadDate_ID4>2019-04-30</ReadDate_ID4>

Days Field: <Days_ID33>32</Days_ID33>

Does anyone know how to do this?

Thanks,

Tony

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center