about date format

Highlighted
Occasional Contributor

about date format

Hi,

I'm trying to import date data.

I failed importing as date format, so changed to text then succeeded.(below "week date")

Next I'm thinking that changes to date format.

So I tried using Mid function and Date function, but the value wasn't filled with cell.

What should I do or is there good way to import date??

 

Best regards.

q.PNGw.PNG

 

 

Message 1 of 5
4 REPLIES 4
Certified Master Anaplanner

Re: about date format

Hi,

 

Can you please share a screenshot of the date that you are trying to import into Week Date, so I can look at how the source date is formatted?

Message 2 of 5
Occasional Contributor

Re: about date format

Thank you for your reply
I revised..
Message 3 of 5
Certified Master Anaplanner

Re: about date format

Hi @Takamasa ,

 

Year should be formatted like 2018,2017.. So concatenate 20 with Year.

001.png

 

Regards,

Vignesh M 

Message 4 of 5
Occasional Contributor

Re: about date format

I got it. Thank you for always!
Message 5 of 5