Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My below script :-
[Posting Date] as [date_sales],
Return :-
01.02.19
01.03.19
01.04.19
01.07.19
I need to return as below format :-
6/1/2017
8/1/2017
9/1/2017
10/1/2017
11/1/2017
Paul Yeo
maybe this:
Date( Date#([Posting Date], 'DD.MM.YY'), 'DD/YY/YYY') as [date_sales]
Hi,
try this:
Date(Date#(Replace([Posting Date],'.','/'),'MM/DD/YYYY'),'D/M/YYYY') as [date_sales]
maybe this:
Date( Date#([Posting Date], 'DD.MM.YY'), 'DD/YY/YYY') as [date_sales]
Hi All
Thank you very much for your sharing.
Paul