No of days

[pradeep_nov18]

Hoew derive the no of days from starting of the year to current date in datastage.

Please help on this.

Thanks,

[anbu]

Code: Select all

DaysSinceFromDate(TimestampToString(CurrentTimestamp(),"%yyyy-%mm-%dd"),TimestampToString(CurrentTimestamp(),"%yyyy"):'-01-01')

[pradeep_nov18]

thx for your rply.

Let me analyze.

[pradeep_nov18]

Hi anbu ,

bit confused ,

Suppose my batch date is 15-apr-2010 so i have calculate how manys days are there from 01-01-2010.how to achieve dis

[anbu]

Code: Select all

svMon=Upcase(Field(Inputdte,"-",2))
svMM=If svMon = 'JAN' Then '01' Else If svMon = 'FEB' Then '02' Else ..
svNewDt=Field(Inputdte,"-",3) : '-' : svMM : '-' Field(Inputdte,"-",1)

Convert your input date to yyyy-mm-dd and then use above function

[pradeep_nov18]

Code: Select all

svMon=Upcase(Field(Inputdte,"-",2))
svMM=If svMon = 'JAN' Then '01' Else If svMon = 'FEB' Then '02' Else ..
svNewDt=Field(Inputdte,"-",3) : '-' : svMM : '-' Field(Inputdte,"-",1)

Convert your input date to yyyy-mm-dd and then use above function

i analysed your derivation.

It is working.

can you please let how to reterive total no of days in that month.

Thanks for your help.

Thanks much .

[Kryt0n]

The date format yyyy-mmm-dd should be able to parse your input field - unless it is case sensitive but that would be silly!

That way you don't need to figure out what month it is

[pradeep_nov18]

The date format yyyy-mmm-dd should be able to parse your input field - unless it is case sensitive but that would be silly!

That way you don't need to figure out what month it is

Ya date format is same as above but i want to is any other function to achieve like eg:DaysSinceFromDate similar to daysfromthe month.

Thanks for the your inputs.

[Kryt0n]

What is wrong with DaysSinceFromDate? Why would you need a different function if this achieves your aim?

If you are after something different then you will need to explain the problem more.

[ray.wurlod]

I agree. DaysSinceFromDate() can answer both questions (since start of year and since start of month).