Calendar Object

[#1]

Hello,

I want to get the data in between to dates.

using the Calendar Object

Attaching the files.

Thanks and Regards,

Priya

[Sokkorn]

Hi priya,

Your set analysis will not work due FinalDate in format MM/DD/YYYY and vFromDate in number fomat.

My suggestion is create a new field for Set Analysis

Directory;

LOAD [First Name],

     [Second Name],

     Address,

     Designation,

     Sal,

     Date(Date,'DD/MM/YYYY') as FinalDate,

     Floor(Date)    AS [_FinalDate]

FROM

Book1.xlsx

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

============================================

And use this set analysis Sum( {$<[_FinalDate] = {">$(vFromDate)<$(vToDate)"}>} Sal)

Regards,

Sokkorn

[#3]

Thanks for the reply.

Can u please rectify my qvw

[Sokkorn]

FYI