Hi Community Members Can you please tell me to convert the Odate to desired date format like i have a excel value as any number Thanks

Hi @SP_Bot Try this: [image] Convert OAdate format into ("dd/mm/YYYY") Activities Hi @shiv.mandal Try This DateTime.FromOADate(44200.5).ToString("dd/MM/yyyy") [image] Hope it will helps you slight_smile Cheers!!

Excel Number To Date

Help Studio

Nawazish_Ahmad (Nawazish Ahmad) June 21, 2024, 10:29am 4

Hi @SP_Bot

Try this:

Topic		Replies	Views
Date time (String) from Data Table to OA Date (serial number) Studio studio , question , variables_management	3	2007	November 3, 2021
OA Date Conversion to Date Value Help activities , string , question	5	5146	December 2, 2019
Change Format in Excel (General to Date) Help	15	6843	September 22, 2019
Converting Number format into Date Format Studio studio , question , designer_canvas	5	337	May 30, 2024
Is it possible to convert date to OA date format? Off-Topic Discussions studio	8	5169	February 8, 2019

Excel Number To Date

Related topics