Date conversion

How to convert a string date value to a actual date which is coming from the Folder's AdditionalProperties field ?

Find more posts tagged with

Comments

How to convert a string date value to a actual date which is coming from the Folder's AdditionalProperties field ?

Hi,
Check this thread:http://devnet.interwoven.com/forums_vb/showthread.php?t=22598&forumid=49&highlight=string+date+actual

Hope it will give you some pointers.

Thanks,
Santosh

Saumit

Thanks for pointing out that post!

Anyway, still I'm having problem to convert a string like 1235001600000 to a date format like mm/dd/yyyy".

Please help me with some code snippet.

Thanks.

santosh013

Thanks for pointing out that post!

Anyway, still I'm having problem to convert a string like 1235001600000 to a date format like mm/dd/yyyy".

Please help me with some code snippet.

Thanks.

Where you want to implement this?
What are you trying to achieve?
Give me some idea so that I can try to give you some sort of solution.

Thanks,

Saumit

I'm using C# with .Net 2 framework.

I just want to fetch the folder profile values of CUSTOM21 to CUSTOM23 with the proper date formate like mm/dd/yyyy.

santosh013

I'm using C# with .Net 2 framework.

I just want to fetch the folder profile values of CUSTOM21 to CUSTOM23 with the proper date formate like mm/dd/yyyy.

Hi,
I work in java.
I hope the VB function link might have given you some hint.
Still,I tried to get closer to your logic is in this thread.
http://bytes.com/groups/net-c/460827-converting-dos-date-mmddyyyy-format-c

HTH.

Sincerely,
Santosh

Migrateduser

Hi

I think what you are getting from the custom12 field is the ticks, to get a DateTime from this and format it you can use the following code:

DateTime iDate = new DateTime(1235001600000); //the number you get from custom21
String formatDate = iDate.ToString("yyyy/MM/dd");

Regards
Scott

Saumit

I fixed the problem.
Actually the date information coming from the worksite server while fetching AdditionalProperties of a folder profile, the date format used to be with the base value of 01.01.1970.

So, we need to convert the date value like the below code snippet...

long dateValue = 1235001600000 / 1000;
DateTime dateTime = new DateTime(1970,1,1);
DateTime newDateTime = dateTime.AddSeconds(dateValue);

this newDateTime object will have the actual date value which is required to convert.