DSXchange

Hi,

I have a requirement like this I want to minus -1 day from the date .
For Ex. If I have date 99991231, I want to have 99991231-1 i.e 99991230.
how to achieve this. please help me




Thanks,
Somaraju

Hi ,
U can solve such a requirment by converting the Input Date to Julian and subract one from the result

DateFromJulianDay(JulianDayFromDate(Input_date) -1)

Somu

Try DateFromDaysSince Function. This functions adds an integer to the baseline date and returns date.

Regards

Hi Rino,


sorry my requirement is not only for 9991231 and I have dates othr than that 19980204. I want to subtract 1 from these dates.




Thanks,
Somaraju

Read the response again. It IS a solution to your question.

Hi ray,

Thanks for reply. My requirement is I have a date with sql type char '19800412' and I want to minus one from this so I have to get '19800411' with sql type char. When I used DateFromDaysSince function.I getting an error since my requirement is with char sql type I tried like this in transformer I gave (DSLink.Validfromdate-'01') Iam getting an output as 1.99707e how to get my output as 19970701 please help me


Thanks,
Somaraju

Hi SomaRaj,

First you have to convert char date to date data type then use DateFromDaysSince, U will get the result.

Ex:

DateFromDaysSince(-1, StringToDate("YourdateValue","%yyyy%mm%dd"))

Rgds,
Rao.

somu_june wrote:Hi ray,

Thanks for reply. My requirement is I have a date with sql type char '19800412' and I want to minus one from this so I have to get '19800411' with sql type char. When I used DateFromDaysSince function.I getting an error since my requirement is with char sql type I tried like this in transformer I gave (DSLink.Validfromdate-'01') Iam getting an output as 1.99707e how to get my output as 19970701 please help me


Thanks,
Somaraju

Hi Rao,

Iam getting an error like this when I used your logic


APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "**********" for conversion "date=date_from_days_since[**********](int32)": APT_Conversion_Date_DaysSince: Invalid Date [**********] used for date_from_days_since type conversion.

datefromdayssince is taking int32 as input how to achieve in my case.


Thanks,
Somaraju

Somu

Your Input is Char and Output is Char again. So you need to follow the steps

1. Convert Chat to Date using StringToDate Function
2. Use DateFromDaysSince Function to the result of Step 1 to Substract 1 day from the result.
3. Convert Back your date result to Chat type again using DateToString function.

Regards

Slightly differently-named functions if you prefer to use Modify stages.

Hi Rasi,

I followed the steps you said but Iam getting the same error as I mentioned above post. I think this error is because of the function datefromdayssince.I think it will take only int(32) value or Iam making a mistake in conversion that is (%yyyy%mm%dd). Correct me if Iam wrong

DateToString(DateFromDaysSince(-1,StringToDate("Frm_Src.ValidFromDate","%yyyy%mm%dd")))


Thanks,
Somaraju

Somu

I had test with your code by substuting the input to hard coded value
DateToString(DateFromDaysSince(-1,StringToDate("20060726","%yyyy%mm%dd")))

I am getting the result = 2006-07-25 which is what you would expect. Check whether your input is correct. You can cut and paste the above code in your job to see whether it gives you the correct result

somu_june wrote:Hi Rao,

Iam getting an error like this when I used your logic


APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "**********" for conversion "date=date_from_days_since[**********](int32)": APT_Conversion_Date_DaysSince: Invalid Date [**********] used for date_from_days_since type conversion.

datefromdayssince is taking int32 as input how to achieve in my case.


Thanks,
Somaraju

This happens when the StringToDate fails to parse a date using the provided pattern.

To test why,

In the transformer, split this step into 2 seperate stage variable derivations:
1. ConvertedDate(DATE)<-- StringToDate(<IN.Date>,"%yyyy%mm%dd")
2. and the subtracted value using If isValid(ConvertedDate) then Subtract Value else 0.

Add another output link to the transformer that writes to a reject sequential file(Or a peek stage.. but I prefer Sequential Files) to capture the rows and values for which this conversion fails.


IHTH

Hi,

Thanks for every one. My problem was solved why Iam getting that error is my output is char(8 and when I used rasi steps I got my output as 2006-07-26 but I want as 20060726 so I coded like this to achieve my target


DateToString(DateFromDaysSince(-1,StringToDate(Dslink.Validfromdate,"%yyyy%mm%dd")),"%yyy%mm%dd")


Thanks,
Somaraju