topic Re: Date Formating in QlikView

Date Formating

tmumaw — Sat, 16 Nov 2024 02:19:41 GMT

Hi all,

I'm trying to format a date and having issues. I need it in a MM/DD/YY format and it keeps putting it in a MM/DD/YYYY format. My input is MM/DD/YY. Here's my statement:

If([Years Serv] = 0,
Date(Date#(AddMonths([Hire Date],1,'MM/DD/YYYY'),'MM/DD/YY'))) as Days_30,

Re: Date Formating

StarinieriG — Wed, 02 Oct 2019 14:28:53 GMT

Hi,

try this expression

If([Years Serv] = 0,

Date(AddMonths(Date#([Hire Date],'MM/DD/YYYY),1),'MM/DD/YY')) as Days_30,

Re: Date Formating

tmumaw — Wed, 02 Oct 2019 14:21:29 GMT

Any idea on bracket alignment....

Re: Date Formating

sunny_talwar — Wed, 02 Oct 2019 14:34:56 GMT

How about this

Date(If([Years Serv] = 0, AddMonths(Date#([Hire Date], 'MM/DD/YYYY'), 1)),'MM/DD/YY') as Days_30

or just this

Date(If([Years Serv] = 0, AddMonths([Hire Date], 1)), 'MM/DD/YY') as Days_30

Re: Date Formating

tmumaw — Wed, 02 Oct 2019 14:59:42 GMT

Thanks Sunny the first one worked great.