Logic on date

[panipat1990]

Dear Team,

I stuck a requirement.i have two field.ID And Date. For this i am sharing excel.

Case is IN Date column we have More And More Dates.

But i want to only Current month's Min Date.

Suppose Our Current Month is Dec. in date Column we have dec's Month Date is 04/12/2016,06/12/2016,07/12/2016,08/12/2016,10/12/2016.

But i want to date only current's month min date means 04/12/2016.  Other Show Null

How is it.Kindly help me.

[sunny_talwar]

May be this?

Table:

LOAD Article,

    GRC_Date

FROM

[..\..\Downloads\Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Right Join(Table)

LOAD Article,

  Min(GRC_Date) as GRC_Date

Resident Table

Where MonthStart(GRC_Date) = MonthStart(Today())

Group By Article;

[parimikittu]

Hi Gourav,

Can you please share the desired output as well?

[panipat1990]

Dear  sunny,

But  it  showing  current  month's  all  dates.but I  want  to  current

month's  minimum  date .like  01/12/2016....only  one  date . How  is  it 

[sunny_talwar · Accepted solution]

Try this:

Table:

LOAD Article,

    GRC_Date

FROM

[..\..\Downloads\Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Right Join(Table)

LOAD Min(GRC_Date) as GRC_Date

Resident Table

Where MonthStart(GRC_Date) = MonthStart(Today());

[panipat1990]

It  is  working . ..but  in  frontend . .when  I  create  one  column  of  max  of GRc_DATE.then

not  working . .kindly  help  me  for  resolving  this  issue . ..

I  have  2  field  date  or  article . ....but  one  column  is  derived  max  of  GRc_DATE   in  frontend .

another  column  is  derived  above  your  code  ....

article         max                           min 

1001       10/12/2016       01/11/2016

[#7]

Hi gourav,

I think

According to sunny,

Table:

LOAD Article,

    GRC_Date

FROM

[..\..\Downloads\Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Right Join(Table)

LOAD Min(GRC_Date) as GRC_Date

Resident Table

Where MonthStart(GRC_Date) = MonthStart(Today());

This is the correct answer.

so please close the question by selected the sunny reply.

[sunny_talwar]

Not sure I understand Gourav

[panipat1990]

Dear  sunny 

I  have  two  fields  one  is  article  code  and  second  is  date . And  I  want  to  show in  straight  table  min  and  max  of  GRC_DATE ...max  date  is  simply  derived  max  of  GRc_DATE ..

but  in  min  date  column  I  required  current  month's  minimum  date which  are  you  derived 

but  in  max  date  column  nothing  showing . ......so  kindly  help  me  for  resolving  this  issue .

[panipat1990]

Still  waiting