Date Formating

[tmumaw]

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,

[StarinieriG]

Hi,

try this expression

If([Years Serv] = 0,

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

[tmumaw]

Any idea on bracket alignment....

[sunny_talwar · Accepted solution]

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

[tmumaw]

Thanks Sunny the first one worked great.