Unable to read current date from excel

Hi Guys,
1.) I stored date as below in excel. jobRunDate=TEXT(now(),“dd/MM/yyyy”). this returns me current date.
2) During initialization of process i am storing this in Dictionary object.
3) While retrieving Config(“jobRunDate”).toString i am getting value as “DD08YYYY”.

what can be the reason.?


Working fine for me.



Share your workflow file and excel

Thanks Varun. Found the issue. Date format i given as “DDMMYYYY” all caps which is wrong. it has to be “dd/MM/yyyy”

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.