only date should filter instaed of text

[#1]

Hi All,

I have field which is having data like string and date also but i want to filter data whose having only date fields instead of string records,

Ex: Date

     Before 99

      1/9/2009

      2/9/2010

BUt I want only dates records i dnt want first record as an output.QlikTech Admin

[senpradip007]

Try this,

Load

Date(Date, 'DD/MM/YYYY') As Date

From <Data Source>;

[jsingh71]

Hi Rupali,

Find example in attachment.

--Jai

[tresesco]

Rupali,

If you can find a pattern to filter, you can do it. Say, for example, from your sample data if I take that date data format would be like DD/MM/YYYY, then may be you can try like:

Load

          YourField

From <> Where IsNum(Date#(Trim(YourField), 'DD/MM/YYYY'));

[maxgro]

you ca use IsNum or IsText to filter your records in the script