Converting text field to a date

[#1]

The format for [RECEIVED DATE] is 20130402.  I need to get all the records that are 2013 or greater.  I've tried Num#(Left([RECEIVED DATE],4) > 2013, , but not having any luck.  Can someone help me, please.

[jerem1234 · Accepted solution]

try this:

Date(Date#([RECEIVED DATE], 'YYYYMMDD'), 'YYYY')>=2013

[#3]

If that does not work, try changing it on the script when you load the data:
SET TimestampFormat='YYYYMMDD';
That will recognize that format as being a date

Regards,

Pablo

[MayilVahanan]

HI

Try like this

Year(Date#([RECEIVED DATE], 'YYYYMMDD')) >= 2013

[VishalWaghole]

Hi

Please try this

Date( Date#([RECEIVED DATE], 'YYYYMMDD'),'YYYY') >= 2013

and if RECEIVED DATE having Timestamp formate then

try this

Date( Date#([RECEIVED DATE], 'YYYYMMDD hh:mm:ss'),'YYYY') >= 2013

hope that will solve ur problem.

Thanks.

[#6]

Thank you!