Formula to search records with dates
Hi I'm looking for a formula to obtain as a result the records that have a date between a date that I can insert through a date field and another that I can insert into another date field.
I have a date field "From" and date field "To". I would like that by inserting the dates in the 2 fields I can get all the records of the "Jobs" table inside the View field called records. Can you help me, please? Thank you
TRANSLATE with x English Arabic Hebrew Polish Bulgarian Hindi Portuguese Catalan Hmong Daw Romanian Chinese Simplified Hungarian Russian Chinese Traditional Indonesian Slovak Czech Italian Slovenian Danish Japanese Spanish Dutch Klingon Swedish English Korean Thai Estonian Latvian Turkish Finnish Lithuanian Ukrainian French Malay Urdu German Maltese Vietnamese Greek Norwegian Welsh Haitian Creole Persian TRANSLATE with COPY THE URL BELOW Back EMBED THE SNIPPET BELOW IN YOUR SITE Enable collaborative features and customize widget: Bing Webmaster Portal Back
3 replies
-
Hi Guiseppe
You do something like
do as server
let xBeg := 'From Date';
let xEnd := 'To Date ;
select Job where 'From Date' >= xBeg and 'To Date' <= xEnd
end -
You have you TO field and your FROM Field
and put the above script within the view in the formula section
you may not need the do as server (i'm on cloud version) depening on what your on.
also select job should say select jobs - I missed the s off in error
-
Thank you Mel Charles, unfortunately it does not work. Perhaps because there is no indication of the date of origin. I probably explained myself badly. I have a table called "Jobs" where there are records that all have a date field, called "Date". In another table called "Report" I would like to have a record of the records of the "Jobs" table between a certain time interval that I can choose through 2 date fields such as "From" and to ".
TRANSLATE with x English Arabic Hebrew Polish Bulgarian Hindi Portuguese Catalan Hmong Daw Romanian Chinese Simplified Hungarian Russian Chinese Traditional Indonesian Slovak Czech Italian Slovenian Danish Japanese Spanish Dutch Klingon Swedish English Korean Thai Estonian Latvian Turkish Finnish Lithuanian Ukrainian French Malay Urdu German Maltese Vietnamese Greek Norwegian Welsh Haitian Creole Persian TRANSLATE with COPY THE URL BELOW Back EMBED THE SNIPPET BELOW IN YOUR SITE Enable collaborative features and customize widget: Bing Webmaster Portal Back
Content aside
- 2 yrs agoLast active
- 3Replies
- 273Views