This page (revision-4) was last changed on 26-Nov-2021 10:22 by Administrator

This page was created on 26-Nov-2021 10:22 by Administrator

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 1 KB Administrator to previous
3 26-Nov-2021 10:22 1 KB Administrator to previous | to last
2 26-Nov-2021 10:22 1 KB Administrator to previous | to last
1 26-Nov-2021 10:22 1 KB Administrator to last

Page References

Incoming links Outgoing links
ORACLE CASE WHEN
ORACLE CASE WHEN

Version management

Difference between version and

At line 14 changed one line
}}}
}}
At line 25 changed one line
Using the UEEF function, where AS OF date is field number ~[350005] we can ascertain if a passed date field occurs within the month specified by the As Of date, by using this case..when construct:
Using the UEEF function, where AS OF date is field number [350005] we can ascertain if a passed date field occurs within the month specified by the As Of date, by using this case..when construct:
At line 29 changed 2 lines
trunc(to_date(~[350005],'DD-Mon-YYYY'),'MM') and
last_day(to_date(~[350005],'DD-Mon-YYYY')))
trunc(to_date([350005],'DD-Mon-YYYY'),'MM') and
last_day(to_date([350005],'DD-Mon-YYYY')))
At line 37 changed one line
;{{trunc(to_date(~[350005],'DD-Mon-YYYY'),'MM')}}:(A) This will take the passed As Of date and determine the first day of the month
{{trunc(to_date([350005],'DD-Mon-YYYY'),'MM')}}
At line 39 changed one line
;{{last_day(to_date(~[350005],'DD-Mon-YYYY'))}}:(B) This will take the passed As Of date and determine the last day of the month
(A) This will take the passed As Of date and determine the first day of the month
At line 41 changed one line
;{{CASE WHEN (to_date(~,'DD-Mon-YYYY') between (result A) and (result B)}}:(C) will evaluate the variable date used if it is between the first and last day of the month and then return ‘C’, otherwise ‘P’
{{last_day(to_date([350005],'DD-Mon-YYYY'))}}
At line 43 added one line
(B) This will take the passed As Of date and determine the last day of the month
At line 44 changed 3 lines
----
![Notes|Edit:Internal.ORACLE+CASE+WHEN]
[{InsertPage page='Internal.ORACLE+CASE+WHEN' default='Click to create a new notes page'}]
{{CASE WHEN (to_date(~,'DD-Mon-YYYY') between (result A) and (result B)}}
(C) will evaluate the variable date used if it is between the first and last day of the month and then return ‘C’, otherwise ‘P’
This page (revision-4) was last changed on 26-Nov-2021 10:22 by AdministratorTop