Fetch only Date

[help4qv123]

Hi,

'I have a database in which one of the column has dates and some duplicate values or records in it. i need to show only count(date).

plz check the  attachmnt

[vardhancse]

Hi,

in order to get date/month.year from a field is possible using

Date(Floor())

month()

Year()

functions.

[Anonymous]

Here you have many problems :

1. It is not recommended to have junk data ('dddd','NA')in source itself (Need to talk your source team to clean the data )

2. Your column is not in date format in excel itself.

Solution :

if you know the junk values you can use if statement and filter the data

like

if (match(Date,'dddd','asd','N/A','etc')=0,' ',date) as CorrectDate

thanks

BKC

[help4qv123]

in database its in date format. can we solve if it is in date format.

[PrashantSangle]

Hi,

If it contain only date then use

count(DISTINCT Date)

Regards

[help4qv123]

It doesn't work. it contain date with some other values like alphabetic, numeric...etc...i need the count of only dates.

[PrashantSangle]

Hi,

Then you have to create flag in script which identify which is proper date and which is not date.

and use that flag in your set analysis.

like count({<Flag-={"Not Date"}>}DISTINCT Date)

Regards

[#8]

You can use

Count(DISTINCT FieldName)

[anbu1984]

Script

LOAD Date#(@1,'DD-MMM-YYYY') As Date,

     @2

FROM

sampl.xls

(biff, no labels, table is Sheet1$);

Try this expr in Text box

=Count(If(IsNum( Date),1))

[nirmalraj_kj · Accepted solution]

Find the attachment hope it will helps you