Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Sign up

Sign up | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
Maximo Oracle SQL for last day of month
May 15, 2020
10:14 am
Avatar
cgregory
Member
Members
Forum Posts: 45
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

Hello, 

I am having a difficult time creating an Action to populate a field with the last day of the month. Oracle DB.

I tried several ways without success below, thank you in advance. 

LAST_DAY(targcompdate) 

add_months(trunc(sysdate,’MM’),1)-1

trunc(trunc(sysdate,’MM’)+33)-1

May 18, 2020
1:12 pm
Avatar
cgregory
Member
Members
Forum Posts: 45
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

anyone?

July 8, 2020
12:48 pm
Avatar
cgregory
Member
Members
Forum Posts: 45
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

🙁

Forum Timezone: America/New_York

Most Users Ever Online: 54

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

sun kim: 60

madd0g17: 59

v.barsamov: 51

Maximofresher: 45

cgregory: 45

matta0990: 33

Member Stats:

Guest Posters: 0

Members: 14009

Moderators: 0

Admins: 3

Forum Stats:

Groups: 1

Forums: 8

Topics: 1564

Posts: 4277

Newest Members:

Daniel Trujillo, Madge Stringfield, Sima Howard, Columbus Ainsworth, R B, Maricruz Kabu

Administrators: Chon: 1118, kristensibilia: 0, Joe Grassia: 0