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 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')}}
{{trunc(to_date(~[350005],'DD-Mon-YYYY'),'MM')}}
At line 41 changed one line
{{last_day(to_date([350005],'DD-Mon-YYYY'))}}
{{last_day(to_date(~[350005],'DD-Mon-YYYY'))}}
This page (revision-4) was last changed on 26-Nov-2021 10:22 by AdministratorTop