changing date field appearance in OBIEE
in Eloqua
there are various ways to change the appearance of a Date field.
column Properties
column properties>tab date format>tick overide Default Date Format>select date format that is most applicable to your date requirements (you can change) for example (dd MMMM yyyy h:mm:ss tt) > select custom in the dateformat selector> custom Date format becomes editable> here you can remove the timestamp by leaving "dd MMMM yyyy" in the field
Column Formula
this formula changes the timestamp into a format where the timestamp is changed to mm-YYYY.
For the first validate if the month <10
CASE WHEN MONTH("Email Group Subscribe Attributes"."Email Group Subscribe Date/Time") < 10
Tagged:
0