Re: View Form Issue with Date Field and Epoch Time

2014-01-06 Thread Pierson, Shawn
] On Behalf Of LJ LongWing Sent: Friday, January 03, 2014 11:04 PM To: arslist@ARSLIST.ORG Subject: Re: View Form Issue with Date Field and Epoch Time ** Shawn, What you will need to do is convert it to a Date instead of a Date/Time field if you want to handle before 1970. You will loose fidelity

Re: View Form Issue with Date Field and Epoch Time

2014-01-03 Thread LJ LongWing
Shawn, What you will need to do is convert it to a Date instead of a Date/Time field if you want to handle before 1970. You will loose fidelity of time of day, but will be able to handle any date you will encounter On Jan 3, 2014 9:45 PM, Pierson, Shawn shawn.pier...@energytransfer.com wrote:

View Form Issue with Date Field and Epoch Time

2014-01-03 Thread Pierson, Shawn
Good afternoon, I think I've found a limitation in View Forms that is causing some issues. Basically, for the integration I built with HR data, I'm seeing errors when converting dates for people hired prior to 1970. There aren't any active folks like this, but it seems to be causing issues

Re: View Form Issue

2007-06-13 Thread Webster, Basil
2007 22:23 To: arslist@ARSLIST.ORG Subject: View Form Issue Hello All, ARS 6.3 patch 16 WIN2K SQL2003 I am having a problem creating a View Form from a sql view. This view is a join of several tables in different databases. The JOIN criterion is the record ID for the main table

View Form Issue

2007-06-12 Thread Nall, Roger
Hello All, ARS 6.3 patch 16 WIN2K SQL2003 I am having a problem creating a View Form from a sql view. This view is a join of several tables in different databases. The JOIN criterion is the record ID for the main table. This also happens to be the only column I cannot see after loading

Re: View Form Issue

2007-06-12 Thread Wheeler, Dylan
: Tuesday, June 12, 2007 1:23 PM To: arslist@ARSLIST.ORG Subject: View Form Issue ** Hello All, ARS 6.3 patch 16 WIN2K SQL2003 I am having a problem creating a View Form from a sql view. This view

Re: View Form Issue

2007-06-12 Thread Nall, Roger
Of Wheeler, Dylan Sent: Tuesday, June 12, 2007 4:28 PM To: arslist@ARSLIST.ORG Subject: Re: View Form Issue If it is the Key Field then it will not be selectable in the list of fields. It will be mapped to the view forms Request ID field. -Original Message- From: Action Request

Re: View Form Issue

2007-06-12 Thread Grooms, Frederick W
How big and what type is that column? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Tuesday, June 12, 2007 3:43 PM To: arslist@ARSLIST.ORG Subject: Re: View Form Issue ** Actually

Re: View Form Issue

2007-06-12 Thread Joe D'Souza
@ARSLIST.ORG Subject: Re: View Form Issue ** Actually that is not true. There are two columns that can be mapped to the Request ID field that are in both areas however the column that I want is no where to be found. Also, if I query the view in Query Analyzer logged in as Aradmin I can see

Re: View Form Issue

2007-06-12 Thread Nall, Roger
: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Tuesday, June 12, 2007 4:47 PM To: arslist@ARSLIST.ORG Subject: Re: View Form Issue How big and what type is that column? From: Action Request System

Re: View Form Issue

2007-06-12 Thread Joe D'Souza
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Nall, Roger Sent: Tuesday, June 12, 2007 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: View Form Issue ** I believe it is integer but it may be a big int. I suppose that will make a difference. Roger A. Nall Manager