Retail Predictive Application Server (MOSC)

MOSC Banner

How to compare date type measure with functional keywords "today" or "now"

edited Sep 18, 2017 4:22AM in Retail Predictive Application Server (MOSC) 4 commentsAnswered ✓

Hi experts,

I have a measure which is type "date". The measure is assigned in rule expression as "<meas_D> = now".

But when I tried to calculate a boolean type measure from comparison of them like "<meas_B> = if(<meas_D> == now, true, false)", no "true" is assigned to meas_D.

I guess the reason is "now" returns the date and time, which is different from date only.

1) I wonder beside defining another temp measure to take "now" first, then comparing it with meas_D, if there is another way.

2) can I do caculation on date type measure like add 7 days to 20170912 then it becomes 20170919?

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