[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
reading ddmmyyyy dates
From: |
p666 |
Subject: |
reading ddmmyyyy dates |
Date: |
Mon, 11 May 2009 12:09:42 +0200 |
User-agent: |
Internet Messaging Program (IMP) 3.2.8 |
Hi
to read dates in the form ddmmyyyy (ie with no separator),
I tried
date = number(value, SDATE8)
but this triggers
warning: (SDATE field) Delimiter expected between fields
in date.
is it possible to read dates with date formats in the nodelimiter case ?
otherwise is there a better way than this :
date =
DATE.DMY( NUMBER( SUBSTR(value,1,2), F2.0), Number( SUBSTR(value,3,2), F2.0),
NUMBER( SUBSTR(value,5,4), F4.0) ).
Best,
PB
- reading ddmmyyyy dates,
p666 <=