Date Format Issue

Yahoo Archive
1
Good to know. Thanks Jerry.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jerry W. Rodden
Sent: Wednesday, December 01, 2010 7:08 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Date Format Issue





I had asked Support about this - evidently all date fields in Vantage
are actually Date/Time Fields even if the field is used only for the
date. So when you copy the field, it will always have a time with it
even if the time is always 12:00:00.

Jerry W. Rodden

Staff Administrator

Production Planning

Cardington Yutaka Technologies Inc

Phone: 419-864-8777 ext. 6209

FAX: 419-864-7771

jrodden@... <mailto:jrodden%40yutakatech.com>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
All,

When copy & pasting a date field from a Vantage dashboard to an excel
spread sheet the "time stamp" always comes along with the date even
though the "time stamp" is not visible in the dashboard. Does anyone
know how to not have the "time stamp" appear when I paste the date into
Excel?



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132



[Non-text portions of this message have been removed]
3
Format that column in the spreadsheet to show a date only format.




________________________________
From: Blake Clemens <blake.clemens@...>
To: vantage@yahoogroups.com
Sent: Tue, November 30, 2010 1:52:14 PM
Subject: [Vantage] Date Format Issue

Â
All,

When copy & pasting a date field from a Vantage dashboard to an excel
spread sheet the "time stamp" always comes along with the date even
though the "time stamp" is not visible in the dashboard. Does anyone
know how to not have the "time stamp" appear when I paste the date into
Excel?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
4
Yeah I thought of that but I was hoping there was something I could do on the Vantage side. I was hoping to just be able to "turn off" the time stamp setting somewhere.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Tuesday, November 30, 2010 2:30 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Date Format Issue





Format that column in the spreadsheet to show a date only format.

________________________________
From: Blake Clemens <blake.clemens@... <mailto:blake.clemens%40d-m-c.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tue, November 30, 2010 1:52:14 PM
Subject: [Vantage] Date Format Issue


All,

When copy & pasting a date field from a Vantage dashboard to an excel
spread sheet the "time stamp" always comes along with the date even
though the "time stamp" is not visible in the dashboard. Does anyone
know how to not have the "time stamp" appear when I paste the date into
Excel?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
5
I had asked Support about this - evidently all date fields in Vantage
are actually Date/Time Fields even if the field is used only for the
date. So when you copy the field, it will always have a time with it
even if the time is always 12:00:00.



Jerry W. Rodden

Staff Administrator

Production Planning

Cardington Yutaka Technologies Inc

Phone: 419-864-8777 ext. 6209

FAX: 419-864-7771

jrodden@...







[Non-text portions of this message have been removed]