Dustin, If you are trying to do that in a Run-If or qualification, you can't use 'functions' in those areas...you can only use them in set/push actions....generating a report for everything in January would be something like
'Requisition Date' >= "1/1/2018" AND 'Requisition Date' < "2/1/2018" The reason 'LIKE' doesn't work is because the date is stored as either the number of seconds since Jan 1 1970 or the number of days since 'way back' (don't remember the actual date)....but you can only do like statements on strings, which it's not...so it needs to be mathematical in nature. On Wed, Jan 31, 2018 at 2:00 PM, Fawver, Dustin <faw...@mail.etsu.edu> wrote: > Greetings! > > > > I have a form that includes a date field. There are records with dates > spanning several years. I need to generate a report that returns records > that have a date value for a particular month of the year. For instance, I > may need to find records that have a date that falls in January. I have > tried the following qualifications to no avail. > > > > ‘Requisition Date’ LIKE “1/%” > > MONTH(‘Requisition Date’) = 1 > > MONTH($\Requisition Date$) = 1 > > DATENUM(“m”, $\Requisition Date$) = 1 > > > > It doesn’t like the month or datenum functions, and it flags the first > qualification as having an invalid date value. I’m running this on ARS > 9.1.02. Smart Reporting isn’t an option since I don’t have any ITSM > licenses. > > > > Thanks! > > Dustin Fawver > > Sr. Help Desk Technician > > Information Technology Services > > > > P: 423-439-4648 <(423)%20439-4648> > > itsh...@etsu.edu > > [image: itslogo] <http://www.etsu.edu/helpdesk> > > > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > >
-- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
