Year format

[nareshthavidishetty]

I have year format as 5024 ,5048,5049.I need to convert it as 'YYYY'.

[sunny_talwar]

Where did it come from? Outside QlikView what would 5024 correspond to in YYYY?

[Anonymous]

Did you try with Year()??

[Chanty4u]

try year()

if not chk below

On Format Codes for Numbers and Dates

[nareshthavidishetty]

Hi it came from AS400

Logic used in qlikview

year(FCST) as Year  it gives 5024...

[sunny_talwar]

Can you share the data within FCST?

What do you see when you do

LOAD FCST

FROM Source

[nareshthavidishetty]

Am getting like

1141209

1141210

1141211

1141212.............

[HirisH_V7]

Hi,

Check this ,

Get the Dates Right

Post Sample data.!

-Hirish

[nareshthavidishetty]

Expression used to covert FCFSDT into date format

Date(AddYears(Date(Date#('19'&Right(FCFSDT,6),'YYYYMMDD'),'DD/MM/YYYY'),100*Left(FCFSDT,1)),'M/D/YYYY') as webAppSubmittedDate

[nareshthavidishetty]

I have converted this into date year but am facing the issue as below.I need to remove duplicates