Jump to content
  • 0

Date Format Of Virtual Field





I've been separating the Search and Reports data pages and using the Virtual field set-up to pass parameters.  I've done this a few times before and it works ok.


This time, I require the filter on the search to use  'Date from' and 'Date to' parameters.  However, I can't find a  way of formatting the virtual field such that it passes the dates in UK format, as opposed to US.


Without this, my search is showing up the wrong results, if any.


Any thoughts?





Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Hi, Spearheading!


Have you tried using a Localization?

The idea is to create a Localization, select the last item - "Formatting Standards", set the Region as "English (United Kingdom)", and then assign your DataPage to the Localization.

I found this way on the How-To, "International Dates in Calendar Fields".

Link to comment
Share on other sites

  • 0

Thanks and yes, I've tried the localization which is my normal route for UK stuff.  However, the problem now seems to have grown arms and legs as ALL my applications seem to have reverted to US date format on searches - and these are unconnected in terms of localisations etc.  None of them have virtual search fields so I'm not sure what's going on.  Have submitted support ticket.  Will post outcome.


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...