• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 26
  • Last Modified:

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
0
Gordon Hughes
Asked:
Gordon Hughes
1 Solution
 
OMC2000Commented:
ToText({WO.REQUESTDATE }, "MMM")
0
 
Gordon HughesDirectorAuthor Commented:
Spot on
Thanks
0
 
mlmccCommented:
Crystal also has a MonthName function if you have the month number

MonthName(Month({WO.REQUESTDATE })

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now