How to recode date from 21.9.2019 to 21/9/2019

[paulyeo11]

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

[wade12]

[StarinieriG]

Hi,

try this:

Date(Date#(Replace([Posting Date],'.','/'),'MM/DD/YYYY'),'D/M/YYYY') as [date_sales]

[agigliotti · Accepted solution]

maybe this:

Date( Date#([Posting Date], 'DD.MM.YY'), 'DD/YY/YYY') as [date_sales]

[paulyeo11]

Hi All

Thank you very much for your sharing.

Paul