Forum Discussion
Extract Date
Dear Experts, Can you please help extract the Date from the cells as below :- Thanks & Regards Anupam Shrivastava
In general depends on goals. If we would like to show dates only and don't care about the time, when select columns, Ctrl+1->Number->Date.
If we extract dates, actually we update datetime into datetime value for the given date at 12:00:00AM shown as date only.
If we will do some calculations with dates, for example,
Created is 5-23-2023 11:30:00 PM
Resolved is 5-24-2023 12:30:00 AM
the difference between Resolved and Created will be 0.042 and 1 day for above cases accordingly.