Problem with date

**Vagelisr** · 06-01-2018, 10:54 AM

Hi to all
I use Excel 2003 and i want your help in 2 diff things
1)
I want the current date in format "yyyymmdd" without change the format of the cell

I try this
= "PCL" & TEXT(TODAY();"yyyymmdd") & MID(C16; 13; 15)
and i take this
PCLyyyymmdd590912854457747
The reason i use ; and not , is because i use Greek Office

2)
I want in a cell this format
2018-06-01T17:48:14.622

PS:I don't want to use vba code...

Thanks and regards.

**jeffreybrown** · 06-01-2018, 11:02 AM

Try...

= "PCL " & TEXT(TODAY();"yyyy-mm-dd") & " "&MID(C16;13;15)

**Vagelisr** · 06-01-2018, 11:05 AM

First of all thank you very much jeffreybrown

The point is im facing the same problem if i use only
=TEXT(TODAY();"yyyymmdd")
I receive
yyyymmdd

**jeffreybrown** · 06-01-2018, 11:19 AM

Yes, because that is the format you asked for. If you want the "-" in-between, then use the format I posted.

**Vagelisr** · 06-01-2018, 11:23 AM

I think I did not correctly explain my problem and I'm sorry for this

i use this to take back 20160601 instead of this i take yyyymmdd
They did not show the date at all show only this yyyymmdd

Problem_With_Date.png

**jeffreybrown** · 06-01-2018, 11:28 AM

I'm sorry. I'm a little confused as to your requirement. Can you attack a small sample worksheet with what you desire.

**Vagelisr** · 06-01-2018, 11:35 AM

I hope this help you

**jeffreybrown** · 06-01-2018, 11:46 AM

That Excel file would not open for me. Either try again or can you explain a little clearer what you are trying to make happen?

Using >> =TEXT(TODAY();"yyyymmdd")

I get >> 20180601 >> that is today's date and in the format the formula asks for.

If you want >> 2018-06-01 >> then you use >> =TEXT(TODAY();"yyyy-mm-dd")

I have no idea what and where you are getting this >> 20160601 >> when you are referencing Today()

**Vagelisr** · 06-04-2018, 07:40 AM

Hi and sorry for the delay.

Finally the code don't work because my office is Greek.
Sorry for the confusion jeffreybrown.....
When i change the yyyymmdd with the assosiate Greek characters (εεεεμμηη) in my case work perfect.

Thans again

**jeffreybrown** · 06-04-2018, 07:41 AM

Awesome. Glad you now have your solution.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Problem with date

LinkBack

Thread Tools

Rate This Thread

Display

Problem with date

Re: Problem with date

Re: Problem with date

Re: Problem with date

Re: Problem with date

Re: Problem with date

Re: Problem with date

Re: Problem with date

Re: Problem with date

Re: Problem with date

Thread Information

Users Browsing this Thread

Similar Threads

Problem with Date column reverting to the same date

Advanced filter by date range, international date format problem

[SOLVED] Problem with engaging an ERROR based on a date being <= another date

Date Problem

3 columns; date and two data, problem is sorting and calculating with respect to date

[SOLVED] Date Problem's

[SOLVED] Date Problem's

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions