Unanswered

Date field formatting

(0) Share

Report

Posted on by PPEnthusiast

Hi all,

I have put (dd/M/yyyy) datetime/dateformat in sitesettings of power portal.There is a dob date field on service web page ,which is populated from birthday field of contact record using ajax and it is set using
var x=new Date(res.birthday)
$('#dob').val(x.toString('dd/M/yyyy'))
,where res is result from ajax call ,but I am unable to store dob field in dataverse , dob is showing blank while submitting form on service webpage ,there are no console errors on submission.But if I change the date using date picker and submit form ,it is showing in dataverse table.Can anyone please help me with this.

Thank you

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Saud Ali 812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @PPBeginner ,

Please try below snippet:

// Get your date from api call() var dateValue = new Date(res.birthday); // Get date field var dateField = $("#dis_dateofbirth"); //Replace schema name with your column dateField.val(moment.utc(dateValue).format("YYYY-MM-DD"));

Feel free to share, if you face any issues.

Thanks,
Saud

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
PPEnthusiast 10 on at

Like (1)

Report
Copy link

Link copied!

Hi @saudali_25 ,
Thanks for your reply,
I tried your code but I am getting error and I also want to know why the value set is not showing on the form

Was this reply helpful? Yes No
Saud Ali 812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @PPBeginner ,

Please note that, CRM will accept dates in the format that you've set for column. The error shows the format you're passing to set date is not what you've in CRM. I posted example according to the format that I have. Please change the date format before setting it and it should work.

Thanks,
Saud

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Fubar 8,487 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
As per your other post, set the date value on the datepicker object (not what you think is the field)
// set a default date to a specific date $("#your_fieldname") // input control .next() // the date picker container .data("DateTimePicker") // the date picker object .defaultDate(new Date("2020-01-01"));

Was this reply helpful? Yes No