Nigel Light Contributor
I've lost the month in this date format - any suggestions?
(not a lot to go on in the help here)
Thanks @Nigel Light
Pavan Rao Experian Contributor
Hello @Nigel Light , the Date format string must be dd/MM/yyyy where "MM" (all capitals) is the month. Hope that sorts the date format. Regards, Pavan5
Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.
Thanks @Pavan Rao
This question comes up quite a bit, so here's the full list of letters used in the date and time patterns, and what they mean:
Pattern letters can often be repeated, and the number determines the exact presentation. For example:
Text can be added using single quotes (
Brilliant - very comprehensive and useful
Thanks @Henry Simms
@Steve FarrSuggestion that this should this be added to the User Help screens for the product as I am pretty sure it isn't available (I couldn't find it anyway, though I do have previous by failing to find the tomato sauce in the kitchen cupboard even when it was right in front of me!)