SAC Application Designer - Convert Date DD/MM/YYYY to internal format

Dear Balaji

Try something as below

convert your input to string. then substring it to a date variable. Then use date calculation

var str = "2020.05.05";  <== your input converted to string
var year = ConvertUtils.stringToInteger(str.substr(0,4));
var month = ConvertUtils.stringToInteger(str.substr(5,2));
var day = ConvertUtils.stringToInteger(str.substr(7,2));
var date = DateFormat.format(new Date(year,month,day),"MM/dd/yyyy");

Then use the date function to subtract 2

Regards,

Venkat

All the above code is correct only difference is month start from zero.

0 = jan

1= feb

2 = march

3 = april

4 = may

ETC.

Please refer the below code.

var day_ext = Input_Date.getValue();//Datein DD/MM/YYYY
console.log(day_ext);// My inputdate example :03/04/2020
var year = ConvertUtils.stringToInteger(day_ext.substring(6,10)); 
var month = ConvertUtils.stringToInteger(day_ext.substring(3,5)); 
var day = ConvertUtils.stringToInteger(day_ext.substring(0,2)); 
var date_s = DateFormat.format(newDate(year,month-1,day),"MM/dd/yyyy"); 
console.log(date_s);
var daten=newDate(date_s);//Issue-2 Syntaxerror -Cannot convertstringto Integer
daten.setDate(daten.getDate()-2);//Not sure if this will workfor MM/dd/yyyy format

Hello Venkat,

Thanks for your reply, much appreciated.

I tried your logic and still face the same two issues

var day_ext = Input_Date.getValue(); //Date in DD/MM/YYYY
console.log(day_ext);  // My input date example : 03/04/2020
var year = ConvertUtils.stringToInteger(day_ext.substring(6,10)); 
var month = ConvertUtils.stringToInteger(day_ext.substring(3,5)); 
var day = ConvertUtils.stringToInteger(day_ext.substring(0,2)); 
var date_s = DateFormat.format(new Date(year,month,day),"MM/dd/yyyy"); 
console.log(date_s);// Issue-1 After conversion its 05/03/2020 instead of 04/03/2020

//Given Date -2
var daten= new Date(date_s); //Issue-2 Syntaxerror -Cannot convert string to Integer
daten.setDate(daten.getDate()-2); //Not sure if this will work for MM/dd/yyyy format

1. The date after conversion to new format is wrong, please check the comments in console statement.

2. Can you let me know what date function you refer to subtract 2 days from MM/dd/yyyy?

Regards,

B

Hi,

Thanks for your reply, much appreciated.

It seems there is no direct way to calculate offset of days from user input format or after converting to date MM/dd/yyyy.

Many of the javascript or design studio functions are unfortunately not available/supported in SAC application designer at the moment.

So I had to do the logic at CDS level which solves the issue.

Regards,

B