Skip to main content

Questions tagged [date-format]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
40 views

Power BI embed on SharePoint is not showing UK date format for slicer visual

We have slicer visual on our Power BI report. We need the slicer date display in dd/mm/yyyy format. The slicer is showing correct format before but recently we found that our report's slicer visual is ...
Mark L's user avatar
  • 4,065
1 vote
0 answers
212 views

How to make the date format take the form as DD/MM/YYYY

I am using SharePoint 2016, and InfoPath designer 2013. In InfoPath form, I added a textbox that has Data Type as Date. I changed the formatting of the date to use the English(united kingdom) which ...
Osman Teyeb's user avatar
0 votes
1 answer
226 views

How to refresh/fix calculated creation date field (For different date format), "1899.Dec.30." error?

I am using a calculated field in a custom-list =TEXT(Created,"yyyy-mmm-dd") to change the date format from the original Created date field. At 99% of the time works correctly, but in about 0.4% it ...
Nefri's user avatar
  • 319
0 votes
1 answer
750 views

Setting a date field with JS/Jquery with multple formats

Sounds trivial but seems to be harder than I thought: I want to set a date field in a SharePoint Online (should be compatible with 2016) form via JavaScript/JQuery: $(myDateVieldInput).val('3/17/2018'...
Dave's user avatar
  • 617
1 vote
1 answer
1k views

SharePoint list conditional formatting - US versus UK dates

I've tried my best not to ask for help, but I'm stuck, even after I learned a bit of JS, MomentJS and Client Side Rendering on SP. The code below returns undefined in date column. If you know why, ...
Maciek's user avatar
  • 115
0 votes
1 answer
75 views

Custom Date Formulas not working properly for 2017

I have several custom date formulas setup which all worked fine in 2016. Now that 2017 is here it seems there is some miscalculation happening within the formula, but I cannot tell what the problem is....
Tydis's user avatar
  • 1
3 votes
1 answer
1k views

Format Date in Content Query

I have looked through too many threads about this and have made no progress. So far the following links have helped me the most: Content Query WebPart & Date How to format Date in Content ...
anonymous's user avatar
  • 407
1 vote
3 answers
1k views

How can I convert the format ctx.CurrentItem.Created

I am using SP2013 on-premise. I have applied client side rendering to convert the Item created datetime to specific format. The problem is "ctx.CurrentItem.Created" always return a string format as ...
Mark L's user avatar
  • 4,065
0 votes
2 answers
4k views

How to remove the seconds part from a date and time property

We have a standard Calendar app in SP2013 with some events that we roll up on a homepage using a content search web part (the Two Lines display template). We show two properties: the title and the ...
Piet Schat's user avatar
3 votes
3 answers
43k views

How to change date format to dd-mm-yyyy in SharePoint 2013?

I have a list view webpart which displays start date of calendar list. It displays date in MM/dd/yyyy format (US format). I want to change it to dd/MM/yyyy (UK format). I have tried to change it from ...
love thakker's user avatar
  • 1,136
2 votes
1 answer
1k views

Can anyone color code a column with an if statement?

Here is what I am trying to do. I have a SharePoint 2010 list that I want to color code dates based on that it expires 364 days after the date entered. Example: If the date is older then 334 ...
Christopher Hanson's user avatar
1 vote
1 answer
4k views

SharePoint 2010 REST Date/Time format

In SharePoint 2010 REST API when I call to _vti_bin/ListData.svc/Documents(38)/Created and get JSON response the date/time is returned as /Date(1421146908000)/ (I found some information about it but ...
andrii's user avatar
  • 369
0 votes
2 answers
665 views

Changing the date format in SharePoint 2010

The date format in my SharePoint 2010 Farm is set to the US format (mm-dd-yyyy). I need to make a global change so that the displayed date is in the format dd-mm-yyyy for all documents. Can anyone ...
Nigel's user avatar
  • 71