Forum Discussion

logan_logan's avatar
logan_logan
Helper I
2 years ago
Solved

query on date format

My period column is in "January 1, 2024" format and I want to convert it to "Jan 2024". It worked using format(period, "MMM yyyy") ONLY in text format. But I need it in Date format. The default text ...
  • Kaviraj11's avatar
    Kaviraj11
    2 years ago

    Hi,

    Select your date column or convert it to date column by changing data type  and directly enter simple letters formating string as shown below

     

     

     

     

     

     

Kaviraj11's avatar
Kaviraj11
Solution Sage
2 years ago

Hi,

Select your date column or convert it to date column by changing data type  and directly enter simple letters formating string as shown below