Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a multibox which contains FISYR, FISPD and WEDAT. I want to set a variable (vDate) based on the WEDAT the user selects. Help.
Thanks
HI
Try like this
create a variable, vDate
value: =GetFieldSelections(WEDAT)
hope it helps
HI
Try like this
create a variable, vDate
value: =GetFieldSelections(WEDAT)
hope it helps
Thanks.....That is just what I was looking for.....
One added question. I have another variable based on vDate which looks like this =addmonths(vDate,-12). Is there a way to format the outcome? Currently it's MM/DD/YYYY and I would like it to be YYYY-MM-DD
Use Date(addmonths(vDate,-12),'YYYY-MM-DD')
or set Default date format as 'YYYY-MM-DD'
SET DateFormat='YYYY-MM-DD'; which is at the start of the file
HI
Try like this
Make sure,vDate is a single value, for multiple value is not work
=Date(AddMonths(vDate,-12),'YYYY-MM-DD')
Hope it helps
Thanks
Thanks
Since you are on such a great roll I have one other question. I need to set a variable based on the FISYR_T and FISPD_T from a multibox, then calculate a rolling 12 months based on the selection....any ideas thanks Thom
HI
Is both are FISYR_T and FISPD_T date field?? you want to load data between this values?
vFisyr = GetFieldSelections(FISYR_T)
vFispd = GetFieldSelections(FISPD_T)
=Sum({<Date = {'>=$(=Date(vFisyr))<=$(=Date(vFispd))'}>}Sales)
is not:
vStart =GetFieldSelections(WEDAT)
vEnd =Date(AddMonths(vDate,-12),'YYYY-MM-DD') // AddMonths(vDate,-12) acccording to date format
=Sum({<Date = {'>=$(=Date(vStart))<=$(=Date(vEnd))'},FISYR_T = {'$(vFisyr)'},FISPD_T = {'$(vFispd)'}>}Sales)
edit:
Am in outside. Sorry for incovenience. Tomo will post further.
hope it helps