topic Re: How to Change only Year in Date Field in QlikView

How to Change only Year in Date Field

dunnalahk123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Can Some one help me here, My Question is i have a Date Field in MM\DD\YYYY Format.

in that values i have as below

Example 12\03\2022

08\07\2019

03\24\2018

but i want to Change only Year from that Date field to current year

like below

12\03\2017

08\07\2017

03\24\2017

How can i Achieve it , Some one help me here please.

Thanks,

Re: How to Change only Year in Date Field

sunny_talwar — Wed, 22 Mar 2017 09:52:08 GMT

Try using SetDateYear() function

LOAD SetDateYear(DateField, 2017) as DateField

Re: How to Change only Year in Date Field

sarvesh — Wed, 22 Mar 2017 09:55:23 GMT

You can use the date() function:

date(YourFieldName, 'MM\DD\YYYY')

Hope this helps

Re: How to Change only Year in Date Field

sunny_talwar — Wed, 22 Mar 2017 09:56:43 GMT

Or this:

LOAD SetDateYear(DateField, Year(Today())) as DateField

Re: How to Change only Year in Date Field

dunnalahk123 — Wed, 22 Mar 2017 10:03:04 GMT

Thank You So much . It Works. 🙂

Re: How to Change only Year in Date Field

dunnalahk123 — Wed, 22 Mar 2017 10:04:30 GMT

Thank You For all 🙂

Re: How to Change only Year in Date Field

BI_Dev — Thu, 15 Oct 2020 17:05:24 GMT

@sunny_talwar Hi - I have date as 31-Jan-99

which is 12/31/1999.How can I change this to show as 12/31/2999 ?This column has multiple dates with diff. years, but for this I want to show as 2999.

Re: How to Change only Year in Date Field

sunny_talwar — Thu, 15 Oct 2020 18:15:40 GMT

@BI_Dev Something like this

=Date(SetDateYear(Date#('31-Dec-99', 'DD-MMM-YY'), 2999))

Replace the hard coded value with your field.

Re: How to Change only Year in Date Field

BI_Dev — Fri, 16 Oct 2020 12:38:31 GMT

Awesome - Thank you.