Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
Hi,
try this expression
If([Years Serv] = 0,
Date(AddMonths(Date#([Hire Date],'MM/DD/YYYY),1),'MM/DD/YY')) as Days_30,
Any idea on bracket alignment....
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
Thanks Sunny the first one worked great.