 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] Excel Date Import | Login/Join |
| Member |
When I import an Excel file with Dates, the Date field defaults to Alpha 50 char. Is there any way to import from Excel and have the field set to a date format automatically?This message has been edited. Last edited by: <Kathryn Henning>, WebFOCUS 7.6 Windows, All Outputs | ||
|
| Expert |
first, what do you mean by 'import'? second, excel dates are numeric fields, with values of , say, 41410 (which is today's value); the 'date' appearance is just a mask, just as a smart-date is a mask. the basedate for excel is 1/1/1900 and the basedate for focus is (i forget now, but i think its 1 day earlier, unless you're on unix in which case its 1/1/1970). so you'ld have to take the number from excel and correct it for base change, then display it under a date mask.
| |||||
|
| Virtuoso |
If you mean by "import" that you have created a MASTER file against your EXCEL sheet, then any dates should be automatically defined as a date-time. If you want you can then change the MASTER and use: FORMAT=DMYY, ACTUAL=DATE or any other format you might want. Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| Member |
Should have used the word "upload" the file not "import". Either way, the data for the dates in Excel come over as formatted dates (MM/DD/YYYY) and since they Focus wants to label them as A50, can't do math functions with them. I realize Excel dates are the number of days since 1900, but people think in terms of MM/DD/YYYY. Yes, I can reformat the dates to a number in Excel, bring it over, reconvert it back to a date format, but I was trying to see if there was a way to eliminate the manual steps. WebFOCUS 7.6 Windows, All Outputs | |||
|
| Expert |
well, if they're A50 and mm/dd/yyyy then just parse with the edit function and convert to whatever you need. takes a few steps, but way doable. | |||
|
| Virtuoso |
baron, Could you post your MASTER or at least the date field in the MASTER? Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only Topic | View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |