Identifying month date year from given field.

[deepakqlikview_123]

Hello team,

Please find attached QVW.

Can u plz suggest how to indentify year,month,date from column title.

Thanks,

[Anonymous]

Here you go,

If you want to create a separate List boxes create the expressions like below

Year

right(Title,4)

Month:

TextBetween(Title,' ',' ')

Date:

TextBetween(Title,'',' ')

[#3]

You mean extracting the information from Excel file name?

Regards,

Prabhu

[antoniotiman]

Hi,

Try

Date(Date#(Title,'DD MMM YYYY'))

Month(...............

Year(.........................................

[ashfaq_haseeb]

Hi,

Add the below code in back-end script.

LOAD Title,

     [CDMS AUDIT LOG],

     date(date#(Title,'DD MMMM YYYY')) as Date,

     Month(date#(Title,'DD MMMM YYYY')) as Month,

     year(date#(Title,'DD MMMM YYYY')) as Year,

     [CDMS WSS CONTENT],

     [CDMSLive DATABASE],

     [LOG size CDMS AUDIT LOG],

     [LOG size CDMS WSS CONTENT],

     [LOG size CDMSLive Database],

     [CDMS AUDITLOG VESPA],

     [CDMSLIVE_VESPA DATABASE],

     [LOG size CDMS AUDITLOG VESPA],

     [LOG size CDMSLIVE_VESPA Database]

FROM

(ooxml, embedded labels, table is [CDMS & Vespa Values in Column]);

Regards

ASHFAQ

[anbu1984]

Check this

[#7]

num(SubField(Title,' ',1),00)  -> Day

SubField(Title,' ',2) -> Month

SubField(Title,' ',1) -> Year

Regards,

Prabhu

[Anonymous]

Hi,

Try below,

Date(Date#(Num(Trim(Left(Title, 2)), 00)&Left(Trim(Mid(Title, 3, Len(Title)-6)),3)&Trim(Right(Title, 4)), 'DDMMMYYYY')) as Date

[its_anandrjs]

Try with

For Year

Right(Title,4)

Or

Date#(Right(Title,4),'YYYY')

For Day

Left(Title,2)

Or

Date#(Left(Title,2),'DD')

For Month

PurgeChar(Title,0123456789)

Or

Month(Date#(Title,'DD MMMM YYYY'))

For Date

Date#(Title,'DD MMMM YYYY')

[antoniotiman]

QV with Year,Month,Date