Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello -
I have a data file that has a date field in the format MMM-DD-YYYY.
I have in my script some language to pull the parts of the date I want for my application:
Mid([Line item start date],4,3) AS adSRTmnth,
Mid([Line item start date],8,4) AS adSRTyear,
For whatever reason, the months and years appear as numbers as opposed to the words.
Any thoughts / suggestions?
Thank you.
If you´re using a date field, it´s better to use date functions
Month([Line item start date]) AS adSRTmnth,
Year([Line item start date]) AS adSRTyear,
Try
Month(Date#([Line item start date], 'MMM-DD-YYYY')) as adSRTmnth,
Year(Date#([Line item start date], 'MMM-DD-YYYY')) as adSRTyear,
If you´re using a date field, it´s better to use date functions
Month([Line item start date]) AS adSRTmnth,
Year([Line item start date]) AS adSRTyear,
this works in the scripting, but does not produce any results. When I type in the 'MMM-DD-YYYY' the text remains black, am I doing something incorrectly?