Rank: Member
Groups: Registered, Registered Users
Joined: 5/27/2010(UTC)
Posts: 13
Location: Norton, Ohio
|
Since a Date() function doesn't exist (you gotta be kidding me...), I was looking to do this in an exploration column:
Year() & "-" & Month() & "-" & DayOfMonth()
The ampersand doesn't work for string concatenation, and I don't see in any help materials, posts or books where there even IS a string concatenation operator.
Anyone got a piece of code that does this? TIA.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
|
What are you trying to do that you think you need one?
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users
Joined: 5/27/2010(UTC)
Posts: 13
Location: Norton, Ohio
|
export the date of the exploration to excel in a ONE column fashion instead of using THREE (Y, M, D).
Got an answer for this one?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 12/14/2009(UTC)
Posts: 140
Location: Austria
|
DayOfMonth()+100*Month()+10000*Year();
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
