User login
Sponsored links
Recent blog posts
- How to resubmit on Integration Broker message with DONE status
- Message cannot be changed. Message referenced in runtime tables (Doc ID 660969.1)
- PeopleSoft Object Type List
- PeopleSoft Data Integrity Error (124,85)
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.
date question in SQR
- Login to post comments
Mon, 12/14/2009 - 8:48am
Hi All,
I have date issues in the SQR AS Shown below
one value is AGE-LIMITSTUD=2009-03-03(birthdate+Age-limit)
and another one is (currentdate-30) 14-NOV-2009 .when i compare these two dates it is not working properly.
I can use Edit option which format i need to change these two dates two compare b'cause one is getting (2009-03-03 and another one is 14-NOV-2009 ) please help me on this.
Thanks in advance
sudha
Bookmark/Search this post with
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
| TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
| how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
| How to add custom process in Paycycle PeopleSoft Accounts payable. | PeopleSoft Technical | 06/07/2017 - 4:39am |
Stay updated
CompShack is a user driven Dev2Dev IT community. Developers can ask questions, help answer questions, or just browse code and articles contributed by users. No registration required.
You can register if you want to contribute code samples, share your knowledge at your own blog, and become adored in the community!
Poll
New forum topics
- ADD 24 months starting from current month.(peoplesoft)
- TRC values dropdown
- OHS is rendering XML instead of the view or data
- Search Results
- PS Query - Need Dependency and Prunable examples
- PS HCM AWE - Transaction routing to Requestor for approval, when he is the Delegatee by his 1 up Manager
- how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode
- How to add custom process in Paycycle PeopleSoft Accounts payable.
Recent comments
- Re: PeopleCode Check Number and Check Letter Functions
12 weeks 30 min ago - Re: nVision Tabular Report through PIA with prompts
16 weeks 6 days ago - Re: PeopleSoft PeopleTools Meta-Tables
16 weeks 6 days ago - Re: PS Query - Need Dependency and Prunable examples
18 weeks 4 days ago - Re: Search Results
19 weeks 1 day ago - Re: How to schedule appengine using peoplecode
19 weeks 3 days ago - Re: Mark worked in Worklist page
21 weeks 4 days ago - Re: Calculate the sum for a grid field with out using row ...
23 weeks 22 hours ago - Re: Invalid SNAC client version
26 weeks 14 hours ago - Re: Trace Application Engine Processes Using Process Definitions
31 weeks 6 days ago
Convert them to stings and compare strings.
hi,
Use the "edit" function to convert the date to the desired format and use the "strtodate" function to conver to date format before comparing.