Currentdate-1 ?
Moderators: chulett, rschirm, roy
Currentdate-1 ?
Hi,
Can anyone help me how to calculate currentdate()-1 ?
Thanks
Can anyone help me how to calculate currentdate()-1 ?
Thanks
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Paddu,paddu wrote:here you go to use in transformer
OCONV(ICONV(@Date,"D4-YMD[4,2,2]")-1,"D4-YMD[4,2,2]")
Change the format to meet your requirement
Iconv and Oconv aren't available in PX.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
You can do it inside the transformer. Something like
Code: Select all
DateFromJulianDay(JulianDayFromDate(DSJobStartDate) -1)
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Thanks you very much
I used
It works fine
Thanks again.
I used
Code: Select all
DateFromJulianDay((JulianDayFromDate(CurrentDate())-1))
Thanks again.
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
I think you can remove the extra pair of parenthesis.swades wrote:Thanks you very much
I usedIt works fineCode: Select all
DateFromJulianDay((JulianDayFromDate(CurrentDate())-1))
Thanks again.
Code: Select all
DateFromJulianDay(JulianDayFromDate(CurrentDate())-1)
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE