cancel
Showing results for 
Search instead for 
Did you mean: 

New to Infosteward and Need assistance with Date syntax.

Former Member
0 Kudos
Hello. I am new to this tool. I am in need of assistance with creating filters on views and also rules.

First I am trying to create a view and in the filter I am trying to select records where one date is greater than the current date and another date is = 12/31/9999. I am having problem with the syntax in the filter.

Example:
"SAP HTR".HRP1000.OTYPE = 'S'
AND is_valid_date("SAP HTR".HRP1000.ENDDA, '12.31.9999')
AND "SAP HTR".HRP1001.BEGDA > to_date ('sysdate ()','mm,dd,yy')

This returns no records but there are valid records.


Also if you have any suggestions on how I can learn the proper syntax for rules it would be greatly appreciated. I feel like I understand the process by struggle on the rules.

Thanks!!
Back to top

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Carolyn,

Please refer to this post http://scn.sap.com/message/14487545#14487545

Also it seems that in to_date function you are using mm comma dd comma yy. Is that intentional? Should it be mm dot dd dot yy?

Abhiram

Former Member
0 Kudos

Thanks for your help.

Here was my solution:

"SAP HTR".HRP1000.OTYPE = 'S'

AND "SAP HTR".HRP1000.ENDDA >= sysdate()

AND "SAP HTR".HRP1000.BEGDA >= to_date ('2012.01.01','yyyy.mm.dd')