Proper Date format

[Ankit1988]

Hi.

I have dataset in Excel Format which have only two date field one is [Month of coding] and another is [Accessible Month] and value is in the both field is look like the attach above snapshots.

so let me know with the help of [Accessible Month ] how to generate standard Date format. like in DD:MM:YYYY or DD/MM/YYY Format.

Thanks  

[Chanty4u]

Hi you can try this 

=Date(Date#(MonthOfCoding, 'MMM''YYYY'), 'DD/MM/YYYY')

=Date(Date#(AccebleMonth, 'MMM''YYYY'), 'DD/MM/YYYY')

[Ankit1988]

hi.

try but its showing null value .

its not working

[Chanty4u]

Hi,

i can see  results:

load *,
Date(Date#(MonthOfCoding, 'MMM''YYYY'), 'DD/MM/YYYY') as new;

load * inline [

MonthOfCoding
Oct'2023
];

exit Script;

[Ankit1988]

hi Look My field value is Oct'21/Sept'21/Jul'21 look like that. i try but it showing null value. 

as your result is shown but you try instead of Oct'2023 put this three value Oct'21/Sept'21/Jul'21

[BrunPierre]

Slight change to @Chanty4u's suggestion.

Date(Date#(MonthOfCoding, 'MMM''YY'), 'DD/MM/YYYY') as new;

[Ankit1988]

No its not working showing blank result.

please see value in field [Month of coding] is like 

oct'21

nov'21

sept'21

jun'21

I have only one date field in my data set i.e. [Month of coding]

and on the basis of [Month of coding] I want below fields.

Date

Month

Year

Mont Year

Fiscal Year

[Rams-]

Hi,

Here's my result,

load *,
Date(Date#(MonthOfCoding, 'MMM''YYYY'), 'DD/MM/YYYY') as new_MonthOfCoding;

load * inline [

MonthOfCoding
Oct'21
Nov'21
Dec'21
Apr'21
Jun'21
Jul'21
Sep'21

];

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

[BrunPierre · Accepted solution]

LOAD *,
Date(Date#(Left(MonthOfCoding,3)&Right(MonthOfCoding,2),'MMMYY'),'DD/MM/YYYY') as Date
Inline [
MonthOfCoding
oct'21
nov'21
sept'21
jun'21
];

[Ankit1988]

its working.

but in place of sept'21 its shown blank. how to resolve that.