AEM Asset Metadata: Is there a way to store Node Data Type as "Date" for Simple Date Format Date?

Question

Hi AEM Community,
 
I have done some findings that AEM only accepts long date format (YYYY-MM-DDT00:00:00.000-05:00) as "Date" Data Type for the node. Is there any configuration that can be done to store Simple Date Format (“YYYY/MM/DD”) as "Date" Data Type?
Is there an alternative other than storing the node field as String to store the Simple Date Format? The reason is I am using this Date for the Query Builder API and using it as String won't allow me to query as "daterange" or "relativedaterange" to do the query operations. Any suggestions and best practice to address this issue would really be appreciated.
 
Best Regards,
Anish

Jagadeesh_Prakash · Accepted Answer

@binaryalchemy11  as a OOTB it is not possible but lets customize in sling model. Apart from that i dont see any option which i can think off. But it all dependends on the exact user case

Jagadeesh_Prakash · Answer

@binaryalchemy11 By default, AEM does not provide an option to store a date in the format of "YYYY/MM/DD" as a "Date" data type. However, you can achieve this by writting a custom code to change the format

private Date date;

@ValueMapValue(name = "date")

private String dateString;

SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd");
try {
date = sdf.parse(dateString);
} catch (ParseException e) {
// handle the parse exception
}

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded