Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
When I compare the Month and year in DateColumn1 against DateColumn2, it should tell me that DateColumn1 is less (i.e, earlier) than DateColumn2, even though the Month October in DateColumn1 is a later month compare to Jan, theDatColumn1 is in the past year and DateColumn2 is in the current year.
Case 1: For Eg DateColumn1 = '01-OCT-2013' DateColumn2 = '01-JAN-2014'
Here it should tell me that the difference is 0 as the month and the year match in this case.
Case 2: DateColumn1 = '01-JAN-2014' DateColumn2 = '02-JAN-2014'
Here it should tell me that the DateColumn2 is lesser than DateColumn1.
Case 3: DateColumn1 = '01-Aug-2014' DateColumn2 = '02-JAN-2014'
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!