Date Issue

[#1]

I have a date field that is formatted YYYY/MM. When I run the Year(Field) As Year I get some screwy number. Is there a formula I should be using to be able to parse the year out? Interestingly enough, the Month(Field) as Month works fine.

Any suggestions?

[Miguel_Angel_Baeyens]

Hello,

I'd use the following to extract the proper date and year or month from it

Year(Date#(Field, 'YYYY/MM')) AS Year,Month(Date#(Field, 'YYYY/MM')) AS Month

Hope that helps.

[IAMDV]

Quick Solutions : Left(DateColumn,4)

[#4]

Thank you....is there any additional scripting needed like AS

[Miguel_Angel_Baeyens]

It is, as I wrote above, the example to be added to your actual script.

Table:LOAD Field, Month(Date#(Field, 'YYYY/MM')) AS Month, Year(Date#(Field, 'YYYY/MM')) AS YearFROM file.qvd (qvd); // your datasource here

Hope that helps