How to convert ecxel date example 41640 to date 1/1/2014

[Former Member]

Hi Gurus

I have a requirement where the table is already saved with excel date as 41640 which is 1/1/2014.

Now I need take this value and I need to convert it to 1/1/2014 in sap date format.

Can you please help.

[Former Member]

can you guys please help

[prakashjasti]

Hi Naveen,

Download entire table data in to an excel and change the values in that column as required

and you can

1. Upload it and update the table by modifying the data only with the column required.

2. Upload entire data by removing the previous content.

Note : Remember to take the back up before changing the contents.

Regards,

Prakash.

[Former Member]

Hi Prakash

The issue is 1/1/2014 is converted as 41640 and uploaded. This is done at bpc level.

Now in another program I need to take this 41640 value and I need to change it to 1/1/2014 for futher

processing.

My issue I need to change the value 41640 to 1/1/2014.

41640 is a date which is same as 1/1/2014. For saving 1/1/2014 to the Data base we have made it as

41640 in BPC and we loaded to Data base. Now I need to take this and change this to date format and do further calculation's.

Your inputs are highly appreciated.

Regards

Naveen

[Former Member]

Hi Naveen,

If you are doing the calculation in Excel then use this function this should help you...

?VBA.Format("41640","DD-MM-YYYY")

01-01-2014

You have to loop in the numbers in table and replace it with formatted one.

Regards,

Kumar Santharam

[UweFetzer_se38]

date = '19000101'.

date = date + 41640 - 2.

Because '01/01/1900' = 1 in Excel