Whats up with year

[bobbydave]

I am importing an excel sheet with 2017 text.

I am trying to convert it to a YEAR in QV and it appears as follows.

I've tried

Date#(F1, 'YYYY')     appears as 2017.00000

Date(F1, 'YYYY')       appears as 1905

Year(F1)                    appears as 1905

[sunny_talwar]

May be try this

Year(Date#(F1, 'YYYY')) as Year

[bobbydave]

Appearing as blank now.

Screenshot attached

[sasiparupudi1]

try round(F1)

[bobbydave]

same as above. blank

[sasiparupudi1]

Year(Trim(Subfield(F1,'.',1)))

Year(Date#(Trim(Subfield(F1,'.',1)),'YYYY'))

[sunny_talwar · Accepted solution]

Can you try this

Num(Num#(F1))

or

Num(F1 * 1)

[niclaz79]

Floor(Date#(F1, 'YYYY'))

[marcus_sommer]

It seems that your field contained a string with numbers whereby it isn't a date else it's just a year-value. Therefore try something like this:

num(F1)

or

num(num#(F1, '####.######', '', '.'))

- Marcus

[MarcoWedel]

another one:

MakeDate(F1)