Platform

 View Only

 DateFormat issue

Jump to  Best Answer
  • TBMStudio
Jemyla Nicole Velilla's profile image
Jemyla Nicole Velilla posted Wed November 08, 2023 11:43 PM

Seems like DateFormat function is not working properly for format : "MMM dd yyyy hh:mm a"

I am expecting the result would be something like Nov 08 2023 11:04 AM, but it is showing below result instead:

Currently, my project settings is set to "Locale : Japan" . I have tried to change the Locale in my Project Settings to "United States" and that solved my issue on the format. 


However, we don't want to change the locale to US, because Japan is the correct one to be used (also using Yen for our currency) so it doesn't make sense to change it just for the DateFormat.

I hope there is a way to set the DateFormat properly to whichever locale it may be.

Would like to know your ideas regarding this.


#TBMStudio
Rene Norskov's profile image
Rene Norskov posted Thu November 09, 2023 12:47 PM  Best Answer

@Jemyla Nicole Velilla I suggest that you raise a Support ticket to have it looked at in detail.
Try adjusting the "Parse numerics per locale" setting on the Import step. I know that a date is not a numeric, but I've seen this setting affect other date formatting.
As an aside I suggest that you move your TableInfo() to it's own column and refer to the column in the DateFormat(). This principle is best practice.


#TBMStudio

Related Content