Date

[smilingjohn]

HI All ,

How to convert dte into age ,

Iam attaching a sample data of xl and QVW file , i want to create one more field by name AGE using the dat field .Can someone help me please

Thanks in Advance....

[jagan]

Hi,

Try like this

Age:

LOAD AGE,

Age(Now(), TimeStamp(Timestamp#(AGE, 'M/D/YYYY  hh:mm:ssTT'))) AS Age_Calc,

TimeStamp(Timestamp#(AGE, 'M/D/YYYY hh:mm:ssTT')) AS Date

FROM

[Age.xlsx]

(ooxml, embedded labels, table is Sheet1);

Regards,

Jagan.

[senpradip007]

Have a look at this. May be it will help.

[tamilarasu]

Hi,

Check the attachment.

[bohravanraj]

Timestamp(Timestamp#('10/12/1929 12:00:00AM','M/D/YYYY hh:mm:ssTT'),'M/D/YYYY hh:mm:ssTT') Try Above Code

[PradeepReddy]

try some thing like this...

Age(Date(Today()), Date(Date#(AGE,'M/D/YYYY  hh:mm:ssTT'))) as Age_Yrs

[smilingjohn]

HI Tamil Nagraj

Its not working ,

Please find the attachment of the real time data , i tried to use the logic but its not working

[smilingjohn]

HI Jagan

Its not working ,

Please find the attachment of the real time data , i tried to use the logic but its not working.

[engishfaque]

Dear John,

Please use this one,

Table1:

LOAD

  Age(Date(Today(), 'DD/MM/YYYY'), Date(Date#(AGE,'M/D/YYYY  hh:mm:ssTT'), 'DD/MM/YYYY')) as AGE

FROM

Age.xlsx

(ooxml, embedded labels, table is Sheet1);

Kind regards,

Ishfaque Ahmed

[jagan]

Hi,

Try this script;

LOAD ACCNUMBER,

     BATCODE,

     BIRTHDATEODBC,

     COLLDATEODBC,

     Age(Now(), TimeStamp(Timestamp#(COLLDATEODBC, Date(Date#(SubField(COLLDATEODBC, ' '), 'M/D/YYYY'))))) AS Age,

     COLLTIMEODBC,

     DIREXAM,

     DRUGCODE,

     DRUGNAME,

     PTNAME,

     DRUGRESULT,

     FINALDATEODBC,

     LOCNAME,

     LOCTYPE,

     MO_GROUPCODE,

     ORDERPHYS,

     ORGANISMCODE,

     ORGCODE,

     ORGDUPFLAG

FROM

(ooxml, embedded labels, table is Data);

Regards,

jagan.