Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 2 data sets having 2 different date formats i need to make those 2 into one format
Example 1 :- 08/02/2022 (MM/DD/YYYY)
Example 2:- 08-02-2022 (MM-DD-YYYY)
but I need only one format for both like 08/02/2022 (MM/DD/YYYY)
Thanks in Advance.
@Chinnu3 Please see below. You can use Alt() function to get this done.
NoConcatenate
Temp:
Load Date(Alt(Date#(Date_field,'MM/DD/YYYY'),
Date#(Date_field,'MM-DD-YYYY')),'MM/DD/YYYY') as [Effective Date]
Inline [
Date_field
08/02/2022
08-02-2022
];
Exit Script;
This should resolve your issue, if yes please like and accept it as a solution.
@Chinnu3 Please see below. You can use Alt() function to get this done.
NoConcatenate
Temp:
Load Date(Alt(Date#(Date_field,'MM/DD/YYYY'),
Date#(Date_field,'MM-DD-YYYY')),'MM/DD/YYYY') as [Effective Date]
Inline [
Date_field
08/02/2022
08-02-2022
];
Exit Script;
This should resolve your issue, if yes please like and accept it as a solution.