topic Re: Creating a date in the current year with same MM/DD as older date. in App Development

Creating a date in the current year with same MM/DD as older date.

Anonymous — Sat, 16 Nov 2024 07:16:29 GMT

Hello clever people. Need some assistance with dates please.

We track some MI on our employee longevity so that we can acknowledge employee anniversaries for key milestones. I am loading information from a Sybase DB and base everything off the Employee_Start_Date.

If the start date is 11/16/2008 I would like to create a date reflective of this year so 11/16/2018. I can therefore easily subtract the two dates and see that the employee is celebrating 10 years with the firm. This needs to carry forward for future years too.

In EXCEL is can do this by =DATE(YEAR(NOW()),MONTH(H2),DAY(H2)) where H2 is the start date.

I am not having much success getting this same result in Qlikview. HELP...

Re: Creating a date in the current year with same MM/DD as older date.

lblumenfeld — Sat, 17 Nov 2018 04:09:41 GMT

This formula below works with the data in my sample script when I paste it in a Text object.

=Date(Num(Month(H2)) & '/' & Day(H2) & '/' & Year(Now()))

In my script for this example, I loaded a one-record table with the date you provided.

Dates:
Load * Inline [
Key, H2
1, 11/16/2008
];

You may have to adjust it to your data. Please post a sample of what you're using, in the event that it doesn't work when you plug it in.

I hope this helps.

Re: Creating a date in the current year with same MM/DD as older date.

kmiryalaj — Sat, 17 Nov 2018 06:30:07 GMT

Makedate(Year(today()),Month(H2),Day(H2)) should work.

Re: Creating a date in the current year with same MM/DD as older date.

Gysbert_Wassenaar — Sat, 17 Nov 2018 07:41:10 GMT

You can use the SetDateYear function: SetDateYear('11/16/2008', 2018) -> 11/16/2018

Re: Creating a date in the current year with same MM/DD as older date.

Anonymous — Mon, 26 Nov 2018 18:03:01 GMT

Thanks for the assist. Much appreciated.

Re: Creating a date in the current year with same MM/DD as older date.

Anonymous — Mon, 26 Nov 2018 18:03:49 GMT

Thanks for the help. Appreciate you posting a solution.

Re: Creating a date in the current year with same MM/DD as older date.

Gysbert_Wassenaar — Tue, 27 Nov 2018 07:34:37 GMT

You're welcome. Since you accept it as a solution, would you mind marking it as a solution as well?