Cant get min expression to work properly!

[#1]

Hello I have some data, a set of dates, the number of dates can vary, for example.

25.04.2005

26.08.2009

01.04.2012

I am trying to load where the 1st date is greater than 01.04.2012 and am using the following expression that is not working!

if(min(Date_Time_Slice_From>'01.04.2012'),Date_Time_Slice_From)

Any idea on how to get thisworking would be great,

Paul.

[MayilVahanan]

HI

Try like this

if(Date_Time_Slice_From>'01.04.2012',Date_Time_Slice_From)

[#3]

No that didnt work at all! Ive still got data pre 01.04.2012!!!

[#4]

In ur expression

create one variable for

min(Date_Time_Slice_From)

then use this variable in the expression

it useful

[#5]

How? i've been unsuccessful in using MIn in script

[CELAMBARASAN]

Hi,

Are you using this in script whioch means you can limit this with Where clause

Load *

From Source

Where Date_Time_Slice_From>'01.04.2012';

If 01.04.2012 is not a default date format then you have to format using Date#(Date string, Format) function.

Hope this helps

[MayilVahanan]

HI

PFA

Regards,

R.MayilVahanan

[#8]

no no no. Look at the original example I quoted, I want it where the earliest value is >01.04.2012

your example will load all data pre 2012.

[#9]

I am only interested if the minimum value is 01.04.2012, I dont want to load any records where the earliest value is pre 2012.

[#10]

im using this in table expression

create one variable for

min(Date_Time_Slice_From)

use this variable in expression like

if(date(1/1/2012)<=$(minvar),sum(price))

it work for me i check this