Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Getting the date format

Hi All,

An excel contains a column with values in date format. I wish to check whether the values which are present in the excel file match a particular format of 'DD-MMM-YY'. A new column DateCheck should be created which stores the result. If the column has values in the desired format, then the new column DateCheck would have values as 'Y' else it should have 'N'.

Thanks,

Asma

4 Replies
sunny_talwar

May be like this:

If(yourDate = Date(yourDate, 'DD-MMM-YY'), 'Y', 'N') as DateCheck

Note: I have not tested this and I am not entirely sure if this would work or not.

Best,

Sunny

Anonymous
Not applicable
Author

.... or something like :

     if ( alt ( date#( '22-MAR-15' , 'DD-MMM-YY' ) , 0 ) > 0 , 'Y' , 'N' )      as DateCheck ,

maxgro
MVP
MVP

  if ( IsNum ( date#( excelfield , 'DD-MMM-YY' ) ) , 'Y' , 'N' )

some useful help

Get the Dates Right

MarcoWedel

Hi,

maybe this solution could be extended like this

LOAD somefields,

        If(IsNum(Date#(excelfield, 'DD-MMM-YY')), Dual('Y',1), Dual('N',0)) as DateCheck

FROM yourexcelfile;

in order to be able to use the DateCheck field as logical value like

If(DateCheck, dothis, dothat)

hope this helps

regards

Marco