Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try this
Year(Date#(F1, 'YYYY')) as Year
Appearing as blank now.
Screenshot attached
try round(F1)
same as above. blank
Year(Trim(Subfield(F1,'.',1)))
Year(Date#(Trim(Subfield(F1,'.',1)),'YYYY'))
Can you try this
Num(Num#(F1))
or
Num(F1 * 1)
Floor(Date#(F1, 'YYYY'))
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
another one:
MakeDate(F1)