Parse Timestamp

[KHK]

Hi,

could you please let me know how to convert string to date of "4/1/2022 3:48:00 PM".

[KHK]

@shashidhar_sris , i want to covert the above string Timestamp to date like 2023 January 

[anurag]

@KHK can you try this:

date(

parseTimestamp(

left(

<time_stamp_column>,

12

),

"MMM dd, yyyy"

)

)

[KHK]

@anurag ,Formula working fine for one year, i want to show two years month wise data on graphs, could you please let me know how to do?

[anurag]

@KHK please share more detail. 

- How do you want to display data? What insight are you using? What dimension and measure are you using?

[KHK]

@anurag below is sample data.