AEM 6.4 Update a datetime field changing the valueFormat and value | Community
Skip to main content
N
NitroHazeDev
Level 9
December 29, 2021
Solved

AEM 6.4 Update a datetime field changing the valueFormat and value

  • December 29, 2021
  • 2 replies
  • 4638 views

Hello All,

 

Is there a way to update a datetime field with new values?

If existing value includes a valueformat yyyy-MM-dd'T'HH:mm:ss as persisted in aem and displayed as and I want to just set the value within aem to be 2015-07-26. That is plain yyyy-mm-dd. I do not want to create a new field but use the existing field within a dialog.

Any ideas how i could approach this?

 

I can set it to blank but not with any other value . 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by arunpatidar

Hi,

AEM uses date format yyyy-MM-dd'T'HH:mm:ss to store the date/calender type in JCR.

When you read this value , you can skip the part after yyyy-MM-dd

String dateStr = dateToString(jcrDate, "yyyy-MM-dd");

/**
   * Get string from date for the given format
   * 
   * @param date
   * @param format
   * @return date string
   */
public static String dateToString(Calendar date, String format) {
    if (date == null || StringUtils.isBlank(format)) {
      return StringUtils.EMPTY;
    }
    try {
      DateFormat dateFormat = new SimpleDateFormat(format);
      return dateFormat.format(date.getTime());
    }
    catch (Exception e) {
      LOG.error("Not able to convert date to string : {}", e.getMessage());
    }
    return StringUtils.EMPTY;
  }

 

What is your use case here?

2 replies

DEBAL_DAS
DEBAL_DAS
December 29, 2021

Please review https://blogs.perficient.com/2018/10/18/a-way-to-handle-dates-in-aem/ , I hope this one will help you.

 

Please refer the below screenshot the way I have defined the date field in demo component 

 

 

The value was stored in 'YYYY-MM-DD' format as shown below

I am using AEM 6.5.9.

    N
    NitroHazeDevAuthor
    Level 9
    December 29, 2021

    Hi @debal_das , I wish i could use the approach but requirement is to reuse a date time field with a value format which has hhmmss and then if checkbox is checked, pick only yyyy-mm-dd, hiding the time portion on the pop up.

    I am unable to set any value to it  other than setting it to blank, maybe cause of the format associated to the field yyyy-mm-dd.

    Do you know how i could approach this?

     

     

     

     

     

      arunpatidar
      Community Advisor
      arunpatidarCommunity AdvisorAccepted solution
      Community Advisor
      December 30, 2021

      Hi,

      AEM uses date format yyyy-MM-dd'T'HH:mm:ss to store the date/calender type in JCR.

      When you read this value , you can skip the part after yyyy-MM-dd

      String dateStr = dateToString(jcrDate, "yyyy-MM-dd");

/**
   * Get string from date for the given format
   * 
   * @param date
   * @param format
   * @return date string
   */
public static String dateToString(Calendar date, String format) {
    if (date == null || StringUtils.isBlank(format)) {
      return StringUtils.EMPTY;
    }
    try {
      DateFormat dateFormat = new SimpleDateFormat(format);
      return dateFormat.format(date.getTime());
    }
    catch (Exception e) {
      LOG.error("Not able to convert date to string : {}", e.getMessage());
    }
    return StringUtils.EMPTY;
  }

       

      What is your use case here?

      Arun Patidar
        N
        NitroHazeDevAuthor
        Level 9
        January 12, 2022

        Thanks @arunpatidar .. If date time field was in a  format with hhmmss, i had to fill in 00:00.I went ahead with creating a date field and storing it in hh mm ss but displaying in dd-mm-yyyy format, and while copying i had to clear the date time field and then set it with the value persisted. 

        Terms & ConditionsAccessibility statement

        Loading footer...