Gordon Hughes
asked on
Select month part og a date field
Am trying to create a formula which will only pick up the month within a data/time field
Have tried
if {WO.REQUESTDATE} like (*/01/*) then 'Jan'
But does not work
Gordon
Have tried
if {WO.REQUESTDATE} like (*/01/*) then 'Jan'
But does not work
Gordon
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Crystal also has a MonthName function if you have the month number
MonthName(Month({WO.REQUES TDATE })
mlmcc
MonthName(Month({WO.REQUES
mlmcc
ASKER
Thanks