Unable to read current date from excel

Help Activities
, ,
1

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.?

2

@muthinavenu

Working fine for me.

image

image

Share your workflow file and excel

3

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

4

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