|
PureBytes Links
Trading Reference Links
|
In Excel, assume your date is in cell F5 {in Date format}. Then
equation for AFL format is:
=(YEAR(F5)-1900)*10000 + MONTH(F5)*100 + DAY(F5) {in General format}
-- Keith
cstrader232 wrote:
>I want to match a numeric date variable from an Excel file to a numeric date
>value that AFL understands.
>(has to be numeric to work in a loop)
>
>My options in Excel seem to be:
>
>Number of days since January 1, 1900
>
>"julian" date in yyyy, num days since 1/1 format:
>e.g. 2006153
>
>But can either of these be matched to datetime()?
>
>I don't want to have to use 3 separate numeric variables: M D Y
>
>TIA
>
>
>
>
>
>Please note that this group is for discussion between users only.
>
>To get support from AmiBroker please send an e-mail directly to
>SUPPORT {at} amibroker.com
>
>For other support material please check also:
>http://www.amibroker.com/support.html
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
|